{"id":34142,"date":"2024-01-19T10:19:59","date_gmt":"2024-01-19T09:19:59","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=34142"},"modified":"2024-03-22T20:26:43","modified_gmt":"2024-03-22T19:26:43","slug":"averageif-function","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/averageif-function\/","title":{"rendered":"Excel\u2019s AVERAGEIF Function &#8211; With Examples"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34161 size-large\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-16-1024x576.png\" alt=\"AVERAGEIF Function\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-16-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-16-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-16-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-16.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>The AVERAGEIF function is one of the most used statistical functions in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a>. It allows you to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/standard-deviation-in-excel\/\" target=\"_blank\" rel=\"noopener\">calculate<\/a> the average of a range of numbers based on one condition. For example, let\u2019s say we wanted to know the average sales number for Toyota cars. This is what it would look like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34145 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-1.jpg\" alt=\"AVERAGEIF Function\" width=\"731\" height=\"419\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-1.jpg 731w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-1-300x172.jpg 300w\" sizes=\"(max-width: 731px) 100vw, 731px\" \/><\/a><\/p>\n<p class=\"p1\"><span class=\"s1\"> In this article, we will delve into the steps of how to use Excel\u2019s AVERAGEIF function, providing real-world examples to demonstrate its applications &#8211;<\/span><\/p>\n<div class=\"contents\">\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#1\"><strong>Syntax<\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong>How to Use the AVERAGEIF Function<\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong>Value From Another Cell<\/strong><\/a><\/li>\n<li><a href=\"#4\"><strong>AVERAGING Values Based on Date Range<\/strong><\/a><\/li>\n<li><a href=\"#5\"><strong>Wildcards<\/strong><\/a><\/li>\n<li><a href=\"#6\"><strong>AVERAGEIFS: AVERAGEIF with Multiple Criteria<\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<p>Let us look at each of these methods in detail.<\/p>\n<h4>Download the Excel Workbook below to follow along and understand how to use Excel\u2019s AVERAGEIF Function \u2013<br \/>\n<a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">AVERAGEIF-Function.xlsx<\/span><\/a><\/h4>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/averageif-function\/#Syntax\" title=\"Syntax\">Syntax<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/averageif-function\/#How_to_Use_the_AVERAGEIF_Function\" title=\"How to Use the AVERAGEIF Function\">How to Use the AVERAGEIF Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/averageif-function\/#Value_From_Another_Cell\" title=\"Value From Another Cell\">Value From Another Cell<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/averageif-function\/#AVERAGING_Values_Based_on_Date_Range\" title=\"AVERAGING Values Based on Date Range\">AVERAGING Values Based on Date Range<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/averageif-function\/#Wildcards\" title=\"Wildcards\">Wildcards<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/averageif-function\/#AVERAGEIFS_AVERAGEIF_with_Multiple_Criteria\" title=\"AVERAGEIFS: AVERAGEIF with Multiple Criteria\">AVERAGEIFS: AVERAGEIF with Multiple Criteria<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Syntax\"><\/span><strong><span id=\"1\" style=\"color: #ff0000;\">Syntax<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The syntax for AVERAGEIF is straightforward:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34144 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function.jpg\" alt=\"AVERAGEIF Function\" width=\"259\" height=\"46\" \/><\/a><\/p>\n<p><strong>=AVERAGEIF(range, criteria, [average_range])<\/strong><\/p>\n<ul>\n<li><strong>range<\/strong>: The range of cells that you want to apply the criteria to. In our above example, the range is the Manufacturer.<\/li>\n<li><strong>criteria<\/strong>: The condition that determines which cells to include in the average. In our example, it is Toyota.<\/li>\n<li><strong>[average_range]<\/strong>: (Optional) The actual cells containing values or numbers to average. If not specified, the function will automatically average the range values.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Use_the_AVERAGEIF_Function\"><\/span><strong><span id=\"2\" style=\"color: #ff0000;\">How to Use the AVERAGEIF Function<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Let\u2019s look at this data regarding the <strong>25 bestselling cars of 2023<\/strong>. We are tasked to find the <strong>average unit sold<\/strong> numbers for <strong>Toyota Cars<\/strong> only:<\/p>\n<p>On cell <strong>E3<\/strong>, enter in <strong>=AVERAGEIF(A2:A26<\/strong>. This represents the range of cells that will be tested to determine if they meet the criteria. In other words, the formula will only look for the word \u201c<strong>Toyota<\/strong>\u201d in this range.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34146 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-2.jpg\" alt=\"AVERAGEIF Function\" width=\"742\" height=\"219\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-2.jpg 742w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-2-300x89.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/a><\/p>\n<p>Continue on with the formula <strong>=AVERAGEIF(A2:A26,&#8221;Toyota&#8221;<\/strong><\/p>\n<p>The function will <strong>test each value<\/strong> in the range <strong>A2 to A26<\/strong> to see if it matches the word \u201c<strong>Toyota<\/strong>.\u201d<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-3.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34147 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-3.jpg\" alt=\"AVERAGEIF Function\" width=\"743\" height=\"193\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-3.jpg 743w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-3-300x78.jpg 300w\" sizes=\"(max-width: 743px) 100vw, 743px\" \/><\/a><\/p>\n<p>Finish the formula with <strong>=AVERAGEIF(A2:A26,&#8221;Toyota&#8221;,C2:C26)<\/strong><br \/>\nThis means that for <strong>every value<\/strong> in the range <strong>A2 to A26<\/strong> that matches the word \u201c<strong>Toyota<\/strong>,\u201d the <strong>associated numbers in C2 to C26 will be averaged<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-1.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34145 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-1.jpg\" alt=\"AVERAGEIF Function\" width=\"731\" height=\"419\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-1.jpg 731w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-1-300x172.jpg 300w\" sizes=\"(max-width: 731px) 100vw, 731px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-4.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34148 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-4.jpg\" alt=\"AVERAGEIF Function\" width=\"553\" height=\"480\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-4.jpg 553w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-4-300x260.jpg 300w\" sizes=\"(max-width: 553px) 100vw, 553px\" \/><\/a><\/p>\n<p>As you can see, the formula provided us the total average units sold for Toyota car models.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Value_From_Another_Cell\"><\/span><strong><span id=\"3\" style=\"color: #ff0000;\">Value From Another Cell<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>An easier way to make your <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dynamic-data-list-using-excel-tables\/\" target=\"_blank\" rel=\"noopener\">data more dynamic<\/a> is to use a value from another cell. Let\u2019s take the same data from above. We are still looking for the average units sold numbers for Toyota cars, but this time we will use a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/jump-to-a-cell-reference-within-an-excel-formula\/\" target=\"_blank\" rel=\"noopener\">cell reference<\/a>. We will have the word \u201c<strong>Toyota<\/strong>\u201d in cell <strong>E2<\/strong>.<\/p>\n<p>Enter the formula <strong>=AVERAGEIF(A2:A26,E2,C2:C26)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-5.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34149 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-5.jpg\" alt=\"AVERAGEIF Function\" width=\"686\" height=\"423\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-5.jpg 686w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-5-300x185.jpg 300w\" sizes=\"(max-width: 686px) 100vw, 686px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-6.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34150 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-6.jpg\" alt=\"AVERAGEIF Function\" width=\"556\" height=\"449\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-6.jpg 556w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-6-300x242.jpg 300w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/a><\/p>\n<p>As you can see, the formula returns the average of numbers in <strong>C2:C26<\/strong> that matches the word \u201c<strong>Toyota<\/strong>\u201d from <strong>cell E2<\/strong>.<\/p>\n<p>The great thing about this is that the formula is dynamic. Meaning if we change the text in <strong>cell E2 to Ford<\/strong>, then the formula will calculate the <strong>average units sold for Ford<\/strong> models only.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-7.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34151 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-7.jpg\" alt=\"AVERAGEIF Function\" width=\"554\" height=\"421\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-7.jpg 554w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-7-300x228.jpg 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"AVERAGING_Values_Based_on_Date_Range\"><\/span><strong><span id=\"4\" style=\"color: #ff0000;\">AVERAGING Values Based on Date Range<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Let&#8217;s say you have a dataset with <strong>dates and sales figures<\/strong>. You want to find the <strong>average sales<\/strong> for a <strong>specific month<\/strong>. The AVERAGEIF function can simplify this task.<\/p>\n<p>Enter the formula <strong>=AVERAGEIF($B$2:$B$21,F3,$D$2:$D$21)<\/strong> on <strong>cell G3<\/strong>. We included the <strong>dollar sign ($)<\/strong> because we want to pin down the ranges, B2:B:21 and D2:D21, as <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/dollar-sign-in-excel\/\" target=\"_blank\" rel=\"noopener\">absolute references<\/a>. This way, the ranges will not move even if we apply the formula to the rest of the columns using <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/use-flash-fill-excel\/\" target=\"_blank\" rel=\"noopener\">Flash Fill<\/a>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-18.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34171 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-18.jpg\" alt=\"AVERAGEIF Function\" width=\"692\" height=\"481\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-18.jpg 692w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-18-300x209.jpg 300w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-9.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34153 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-9.jpg\" alt=\"AVERAGEIF Function\" width=\"566\" height=\"417\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-9.jpg 566w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-9-300x221.jpg 300w\" sizes=\"(max-width: 566px) 100vw, 566px\" \/><\/a><\/p>\n<p>This formula will calculate the <strong>units sold<\/strong> for all entries within the month of <strong>January<\/strong>.<\/p>\n<p><strong>Double-click on the square<\/strong> on the bottom right-hand corner of the cell to apply the formula to the rest of the months.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-10.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34154 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-10.jpg\" alt=\"AVERAGEIF Function\" width=\"578\" height=\"417\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-10.jpg 578w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-10-300x216.jpg 300w\" sizes=\"(max-width: 578px) 100vw, 578px\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Wildcards\"><\/span><strong><span id=\"5\" style=\"color: #ff0000;\">Wildcards<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Suppose this is what your data looks like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-11.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34155 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-11.jpg\" alt=\"AVERAGEIF Function\" width=\"303\" height=\"227\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-11.jpg 303w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-11-300x225.jpg 300w\" sizes=\"(max-width: 303px) 100vw, 303px\" \/><\/a><\/p>\n<p>You are tasked with finding the average units sold numbers for Honda car models. It would be tedious to create a formula for each Honda car. We want to This is where the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/filter-by-text-wildcards\/\" target=\"_blank\" rel=\"noopener\">wildcards<\/a> come in handy:<\/p>\n<p>Enter the formula <strong>=AVERAGEIF(A2:10,\u201d*Honda*\u201d,B2:B10)<\/strong>. The <strong>asterisk (*)<\/strong> is the <strong>wildcard<\/strong>, matches any sequence of characters that contains \u201c<strong>Honda<\/strong>\u201d.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-12.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34156 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-12.jpg\" alt=\"AVERAGEIF Function\" width=\"663\" height=\"221\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-12.jpg 663w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-12-300x100.jpg 300w\" sizes=\"(max-width: 663px) 100vw, 663px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-13.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34157 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-13.jpg\" alt=\"AVERAGEIF Function\" width=\"482\" height=\"204\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-13.jpg 482w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-13-300x127.jpg 300w\" sizes=\"(max-width: 482px) 100vw, 482px\" \/><\/a><\/p>\n<p>As you can see, the formula calculated the average sales for all the cars containing the word \u201c<strong>Honda<\/strong>.\u201d<\/p>\n<h2><span class=\"ez-toc-section\" id=\"AVERAGEIFS_AVERAGEIF_with_Multiple_Criteria\"><\/span><strong><span id=\"6\" style=\"color: #ff0000;\">AVERAGEIFS: AVERAGEIF with Multiple Criteria<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>What if you needed to <strong>average the units sold<\/strong> for a <strong>specific model<\/strong> and a <strong>particular month<\/strong>? This is where the AVERAGEIFS Function becomes handy:<\/p>\n<p>Enter the formula <strong>=AVERAGEIFS(D2:D21,B2:B21,F3,C2:C21,\u201dSilverado\u201d)<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-14.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34158 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-14.jpg\" alt=\"AVERAGEIF Function\" width=\"778\" height=\"446\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-14.jpg 778w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-14-300x172.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-14-768x440.jpg 768w\" sizes=\"(max-width: 778px) 100vw, 778px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-15.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34159 size-full\" title=\"AVERAGEIF Function\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-15.jpg\" alt=\"AVERAGEIF Function\" width=\"595\" height=\"422\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-15.jpg 595w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/AVERAGEIF-Function-15-300x213.jpg 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/a><\/p>\n<p>This formula calculates the <strong>average units sold<\/strong> for the <strong>Silverado<\/strong> within the month of <strong>January<\/strong>.<\/p>\n<p><strong>Conclusion:<\/strong><br \/>\nThere you have it! The AVERAGEIF function is one of the most useful tools there are in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Excel<\/a>. Pair it with wildcards and the AVERAGEIFS function for the ultimate data analysis ease.<\/p>\n<p><span style=\"font-weight: 400;\">Learn more about Formulas with our <\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>101 Advanced Excel Formulas &amp; Functions Examples<\/strong><\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The AVERAGEIF function is one of the most used statistical functions in Excel. It allows you to calculate the average of a range of numbers based on one condition. For example, let\u2019s say we wanted to know the average sales number for Toyota cars. This is what it would look like: In this article, we [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":34161,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[1561,3,10],"tags":[260,1410,1558,1560,1559],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/34142"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=34142"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/34142\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/34161"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=34142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=34142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=34142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}