{"id":3805,"date":"2017-04-07T17:06:42","date_gmt":"2017-04-07T15:06:42","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=3805"},"modified":"2017-04-07T17:06:42","modified_gmt":"2017-04-07T15:06:42","slug":"formula-de-promediosi-conjunto-hojas-de-calculo-de-google","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/google-sheets-formulas\/averageifs-formula-google-sheets\/","title":{"rendered":"C\u00f3mo utilizar la f\u00f3rmula AVERAGEIFS de Google Sheets"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;54px|0px|0|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>The<span>\u00a0<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3256534?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">AVERAGEIFS<\/a>\u00a0Google Sheets formula is similar to that of the<span>\u00a0<\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/averageif-formula-google-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">AVERAGEIF<\/a>\u00a0Google Sheets formula, but with a slight difference. While the AVERAGEIF returns the average of values satisfying a single criteria, the AVERAGEIFS formula gives us the average of values subject to multiple criteria.<\/p>\n<p>&nbsp;<\/p>[\/et_pb_text][et_pb_text admin_label=&#8221;Connections T &#8211; Automate beyond importrange &#8211; Horizontal&#8221; module_class=&#8221;sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f7ff&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; max_height=&#8221;300px&#8221; custom_margin=&#8221;20px|0px|20px|0px|true|true&#8221; custom_padding=&#8221;25px|25px|25px|25px|true|true&#8221; sticky_limit_bottom=&#8221;section&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#d9e7ff&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; global_module=&#8221;50462&#8243; theme_builder_area=&#8221;post_content&#8221;]<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\" width=\"250\" height=\"168\" alt=\"\" \/>\n\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\" width=\"150\" height=\"180\" alt=\"39\" \/>\n\n<span style=\"font-size: 22px; font-weight: 600;\">Automate data transfers beyond Importrange<\/span>\n\n<a href=\"https:\/\/www.sheetgo.com\/connections\/\" target=\"_blank\" rel=\"noopener\">Find out how<\/a>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>&nbsp;<\/p>\n<h3>Syntax<\/h3>\n<p><span><strong>AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, \u2026])<\/strong><\/span><\/p>\n<ul>\n<li><span><strong>average_range<\/strong><\/span><span>\u00a0<\/span>\u2013 is the address reference to the range of cells that the AVERAGEIFS formula considers for averaging. Unlike the AVERAGEIF formula, this is the first parameter within this formula.<\/li>\n<li><span><strong>criteria_range1<\/strong><\/span><span>\u00a0<\/span>\u2013 this is the range of cells against which the formula checks for the<span>\u00a0<\/span><span><strong>criterion1<\/strong><\/span>.<\/li>\n<li><span><strong>criterion1<\/strong><\/span><span>\u00a0<\/span>\u2013 is the condition or test that is used to qualify cells within the<span>\u00a0<\/span><span><strong>criteria_range1<\/strong><\/span><span>\u00a0<\/span>for averaging. There are six types of comparisons in general, as listed below. While we can compare both numbers and text using the first two operators, we can only compare numbers using the last four operators.\n<ul>\n<li>Equals (=)<\/li>\n<li>Not equal to (&lt;&gt;)<\/li>\n<li>Greater than (&gt;)<\/li>\n<li>Greater than or equal to (&gt;=)<\/li>\n<li>Less than (&lt;)<\/li>\n<li>Less than or equal to (&lt;=)<\/li>\n<\/ul>\n<\/li>\n<li><span><strong>criteria_range2, criterion2, \u2026\u00a0<\/strong><\/span>\u2013 these are optional and additional ranges and criteria that the AVERAGEIFS formula checks for.<\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h3>Usage: AVERAGEIFS Google Sheets formula<\/h3>\n<p>Below is a sample nutritional information from a select set of foods. Let us try a few examples to establish our understanding of the formula further.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/AVERAGEIFS-google-sheets-1.png&#8221; alt=&#8221;AVERAGEIFS google sheets 1&#8243; title_text=&#8221;AVERAGEIFS google sheets 1&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>We have the sample data populated on the cells A1 through to G10. Please notice the first case has a single criterion, the second one has two and third has three.<\/p>\n<p>Please consider the second case in row # 14. Using the parameters we\u2019ve entered, the AVERAGEIFS formula checks for instances of anything not named \u201cNuts\u201d within the range A2:A10, then checks for occurrences where values in F2:F10 are greater than 0.2, and finally averages the values from the range E2:E10 that are in the rows that qualify the above two conditions.<\/p>\n<p>Now, let us spend a moment on the case in row # 16. Interestingly, the formula returned an error here because it did not find any matching rows for the criteria specified. Zero instance matching implies a divide by zero instance, hence the error.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h3>AVERAGEIFS formula<\/h3>\n<p>And there you go! Use the AVERAGEIFS formula in Google Sheets to return the average of values subject to multiple criteria.<\/p>\n<p>If you\u2019d like to learn more about the various formulas of Google Sheets, why not take a look at our blog post on the<a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/daverage-formula-google-sheets\/\" target=\"_blank\" rel=\"noopener\"><span> DAVERAGE formula in Google Sheets.<\/span><\/a><\/p>\n<p>Alternatively, check out related blog posts below!<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text admin_label=&#8221;Connections T &#8211; Automate between spreadsheets &#8211; Horizontal&#8221; module_class=&#8221;sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f7ff&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; max_height=&#8221;300px&#8221; custom_margin=&#8221;20px|0px|20px|0px|true|true&#8221; custom_padding=&#8221;25px|25px|25px|25px|true|true&#8221; sticky_limit_bottom=&#8221;section&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#d9e7ff&#8221; global_module=&#8221;50460&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/run-automatically-connect-sheet-icons.webp\" width=\"250\" height=\"168\" alt=\"\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\" width=\"150\" height=\"180\" alt=\"39\" \/><\/p>\n<p><span style=\"font-size: 22px; font-weight: 600;\">Automate data transfers between spreadsheets<br \/><\/span><\/p>\n<p><a href=\"https:\/\/www.sheetgo.com\/connections\/\" target=\"_blank\" rel=\"noopener\">Find out how<\/a><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>The\u00a0AVERAGEIFS\u00a0Google Sheets formula is similar to that of the\u00a0AVERAGEIF\u00a0Google Sheets formula, but with a slight difference. While the AVERAGEIF returns the average of values satisfying a single criteria, the AVERAGEIFS formula gives us the average of values subject to multiple criteria. &nbsp; Automate data transfers beyond Importrange Find out how&nbsp; Syntax AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":3846,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"The <a href=\"https:\/\/support.google.com\/docs\/answer\/3256534?hl=en\" target=\"_blank\" rel=\"noopener\">AVERAGEIFS<\/a> formula in Google Sheets is similar to that of the <a href=\"https:\/\/support.google.com\/docs\/answer\/3256529?hl=en\" target=\"_blank\" rel=\"noopener\">AVERAGEIF<\/a> formula, but with a slight difference. While the AVERAGEIF returns the average of values satisfying a single criteria, the AVERAGEIFS formula gives us the average of values subject to multiple criteria.\n<h3>Syntax<\/h3>\n<span style=\"font-family: courier new,courier,monospace; font-size: 14pt;\"><strong>AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])<\/strong><\/span>\n<ul>\n \t<li><span style=\"font-family: courier new,courier,monospace; font-size: 12pt;\"><strong>average_range<\/strong><\/span> - is the address reference to the range of cells that the AVERAGEIFS formula considers for averaging. Unlike the AVERAGEIF formula, this is the first parameter within this formula.<\/li>\n \t<li><span style=\"font-family: courier new,courier,monospace; font-size: 12pt;\"><strong>criteria_range1<\/strong><\/span> - this is the range of cells against which the formula checks for the <span style=\"font-family: courier new,courier,monospace; font-size: 12pt;\"><strong>criterion1<\/strong><\/span>.<\/li>\n \t<li><span style=\"font-family: courier new,courier,monospace; font-size: 12pt;\"><strong>criterion1<\/strong><\/span> - is the condition or test that is used to qualify cells within the <span style=\"font-family: courier new,courier,monospace; font-size: 12pt;\"><strong>criteria_range1<\/strong><\/span> for averaging. There are six types of comparisons in general, as listed below. While we can compare both numbers and text using the first two operators, we can only compare numbers using the last four operators.\n<ul>\n \t<li>Equals (=)<\/li>\n \t<li>Not equal to (&lt;&gt;)<\/li>\n \t<li>Greater than (&gt;)<\/li>\n \t<li>Greater than or equal to (&gt;=)<\/li>\n \t<li>Less than (&lt;)<\/li>\n \t<li>Less than or equal to (&lt;=)<\/li>\n<\/ul>\n<\/li>\n \t<li><span style=\"font-family: courier new,courier,monospace; font-size: 12pt;\"><strong>criteria_range2, criterion2, ... <\/strong><\/span>- these are optional and additional ranges and criteria that the AVERAGEIFS formula checks for.<\/li>\n<\/ul>\n<h3>Usage: AVERAGEIFS Formula<\/h3>\nBelow is a sample nutritional information from a select set of foods. Let us try a few examples to establish our understanding of the formula further.\n\n<img class=\"aligncenter size-full wp-image-3819\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-52.png\" alt=\"AVERAGEIFS Formula - Illustration 1\" width=\"1105\" height=\"526\" \/>\n\nWe have the sample data populated on the cells A1 through to G10. Please notice the first case has a single criterion, the second one has two and third has three.\n\nPlease consider the second case in row # 14. Using the parameters we've entered, the AVERAGEIFS formula checks for instances of anything not named \"Nuts\" within the range A2:A10, then checks for occurrences where values in F2:F10 are greater than 0.2, and finally averages the values from the range E2:E10 that are in the rows that qualify the above two conditions.\n\nNow, let us spend a moment on the case in row # 16. Interestingly, the formula returned an error here because it did not find any matching rows for the criteria specified. Zero instance matching implies a divide by zero instance, hence the error.\n\n&nbsp;","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[55,39,28],"class_list":["post-3805","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-ben-collins","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/3805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=3805"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/3805\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/3846"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=3805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=3805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=3805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}