In effect, this is the AVERAGE and IF formulas combined into a convenient package. So it\u2019s a pretty useful tool that will save you time and get your spreadsheet working more efficiently.<\/span><\/p>\n In this article we will see how this function works, we will also explore some of its basic applications. <\/span><\/p>\n AVERAGEIF(criteria_range, criterion, [average_range])<\/strong><\/span><\/span><\/p>\n <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n Below is a sample of nutritional information from a set of foods and a set of AVERAGEIF formulas applied to it.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/AVERAGEIF-formula-1.png” alt=”AVERAGEIF formula 1″ title_text=”AVERAGEIF formula 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n The spreadsheet has sample data in A1:G10 and AVERAGEIF formulas in H1:J7. Notice that the first two formulas have text comparisons while the last four have number-based comparisons.<\/span><\/p>\n Let\u2019s break down the first formula:<\/span><\/p>\n The formula in row 5 is a little different. The last parameter is not specified so criteria checking and value averaging are both carried out in the same cell range (D2:D10).<\/span><\/p>\n AVERAGEIF returns the average of values satisfying a single criterion, if you want to find the average of values that meet multiple criteria then <\/span>AVERAGEIFS <\/b>is what you are looking for. Learn <\/span>how to use the AVERAGEIFS formula in Google Sheets<\/span><\/a>.<\/span><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]<\/p>\n Do you routinely apply the same formulas to datasets for analysis and reporting? Try <\/span>connecting Google Sheets<\/span><\/a> to move and filter data between one file and another and automate some of your data processing work.<\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" The AVERAGEIF formula in Google Sheets is similar to the AVERAGE formula, but there’s a key difference. Like the name suggests, it only includes a value in the average calculation if it meets certain criteria. In effect, this is the AVERAGE and IF formulas combined into a convenient package. So it\u2019s a pretty useful tool […]<\/p>\n","protected":false},"author":40,"featured_media":3843,"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 AVERAGEIF<\/a> formula in Google Sheets is similar to that of the AVERAGE<\/a> formula, but with a difference. Like the name suggests, it gives us the average of values subject to a specified criteria.\nSyntax of AVERAGEIF in Google Sheets<\/h3>\n
\n
How to use the AVERAGEIF formula<\/h3>\n
\n
Automate your work in Google Sheets<\/b><\/h4>\n
Syntax<\/h3>\nAVERAGEIF(criteria_range, criterion, [average_range])<\/strong><\/span>\n
\n \t
\n \t
Usage: AVERAGEIF 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
![\"AVERAGEIF](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-53.png\")
\n\nWe have the sample data populated on the cells A1 through to G10. Please notice the first two cases are text comparisons while the last four cases are number based comparisons.\n\nPlease consider the first case. The first parameter is the criteria_range<\/strong><\/span>, which is A2:A10. The criterion<\/strong><\/span> is \"Vegetables\". And the average_range<\/strong><\/span> is C2:C10. So, the AVERAGEIF formula checks for instances of \"Vegetables\" within the range A2:A10, then averages the values from the range C2:C10 that are in the rows where it finds \"Vegetables\".\n\nNow, let us spend a moment on the case in row # 5. You'll see that we did not specify the last parameter. In this case the formula is doing both criteria checking and value averaging on the criteria_range<\/strong><\/span> itself i.e. D2:D10.\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-3773","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=3773"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3773\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/3843"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=3773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=3773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=3773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}