{"id":29676,"date":"2023-06-30T00:47:51","date_gmt":"2023-06-29T22:47:51","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=29676"},"modified":"2024-04-06T21:59:36","modified_gmt":"2024-04-06T19:59:36","slug":"sumif-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumif-in-excel\/","title":{"rendered":"A Quick Guide to Using the SUMIF in Excel &#8211; 2 Helpful Examples"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/57F83F75-4082-477F-9D06-AB6B59D02BA9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-29745\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/57F83F75-4082-477F-9D06-AB6B59D02BA9-1024x576.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/57F83F75-4082-477F-9D06-AB6B59D02BA9-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/57F83F75-4082-477F-9D06-AB6B59D02BA9-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/57F83F75-4082-477F-9D06-AB6B59D02BA9-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/57F83F75-4082-477F-9D06-AB6B59D02BA9.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a>Excel, a widely-used spreadsheet software, offers a multitude of <strong>powerful features for managing and analyzing data<\/strong>. One such feature that proves to be extremely useful is <strong>SUMIF<\/strong>. The SUMIF in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sum-a-row-in-excel\/\" target=\"_blank\" rel=\"noopener\">Excel enables you to sum<\/a><strong> values in a range that satisfies a condition.<\/strong><\/p>\n<p>In this article, we will be covering the following topics in detail &#8211;<\/p>\n<p>Let us look at each one of these topics one by one.<\/p>\n<h4>Download the Excel Workbook below to follow along and understand how to use SUMIF in Excel \u2013<br \/>\n<a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-in-Excel.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">SUMIF-in-Excel.xlsx<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"1\" style=\"color: #ff0000!important\">Introduction to SUMIF in Excel<\/span><\/strong><\/p>\n<p>SUMIF is a wisely used Excel function that allows you to <strong>sum the values in a range that meets the criteria<\/strong> that you specify.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/math\/sumif\/\" target=\"_blank\" rel=\"noopener\">SUMIF in Excel is a<\/a> <strong>flexible function<\/strong>\u00a0that may be applied in a wide range of situations, from <strong>determining sales numbers for particular goods or geographical areas to examining client information based on demographics or purchase patterns<\/strong>.<\/p>\n<p>So if you have a list of product IDs in one column and their Sales in another column and want to Sum the sales of only one of the product IDs, then the SUMIF function is the one for you.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"2\" style=\"color: #ff0000!important\">SYNTAX of SUMIF<\/span><\/strong><\/p>\n<p><strong>=SUMIF(<span style=\"color: #0000ff\">Range<\/span>, <span style=\"color: #ff6600\">Criteria<\/span>, <em><span style=\"color: #008000\">[Sum_Range]<\/span><\/em>)<\/strong><\/p>\n<ul>\n<li><strong><span style=\"color: #0000ff\">Range<\/span><\/strong>\u00a0\u2013 The range that is<strong> tested using criteria<\/strong>. Once items in the range are found, their corresponding values in sum_range are added. Required.<\/li>\n<li><strong><span style=\"color: #ff6600\">Criteria<\/span> <\/strong>\u2013 The<strong> criteria that define which cells<\/strong> in the range will be added. For example, criteria can be entered as 32, \u201c&gt;32\u201d, B4, \u201capples\u201d, or \u201c32\u201d. Required.<\/li>\n<li><strong><em><span style=\"color: #008000\">[Sum_Range]<\/span><\/em><\/strong> &#8211; The <strong>range of cells to sum<\/strong>. <em>Optional.<\/em><\/li>\n<\/ul>\n<p>Let us look at an example to help us understand this function better.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"3\" style=\"color: #ff0000!important\">Example of SUMIF function in Excel<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #ff0000\">Example 1<\/span><\/strong><\/p>\n<p>In his example, we want to get the <strong>sum of the sales amounts that are above $15,000<\/strong>. Follow the step-by-step tutorial below &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Enter the\u00a0<strong>SUMIF<\/strong>\u00a0function in cell F3.<\/p>\n<p><strong>=SUMIF<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29688\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-6.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"827\" height=\"668\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-6.png 827w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-6-300x242.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-6-768x620.png 768w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span> <\/strong>Enter the first argument \u2013 <strong>range<\/strong>. Here we have selected the range C2:C89 as it contains all the sales amount.<\/p>\n<p><strong>=SUMIF(C2:C89,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29689\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-7.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"825\" height=\"670\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-7.png 825w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-7-300x244.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-7-768x624.png 768w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span> <\/strong>Enter the second argument \u2013 <strong>criteria. <\/strong>Here we have entered <strong>\u201c&gt;15000\u201d<\/strong> as we want to get the sum of sales where the <strong>sales amount is greater than $15,000<\/strong>.<\/p>\n<p><strong>=SUMIF(C2:C89,&#8221;&gt;15000&#8243;,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29690\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-8.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"826\" height=\"676\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-8.png 826w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-8-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-8-768x629.png 768w\" sizes=\"(max-width: 826px) 100vw, 826px\" \/><\/a><\/p>\n<p>Below we can see, the SUMIF function returns the sum of sales where the sales amount is <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countif-greater-than-0\/\" target=\"_blank\" rel=\"noopener\">greater than<\/a> $15,000.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29691\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-9.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"819\" height=\"671\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-9.png 819w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-9-300x246.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-9-768x629.png 768w\" sizes=\"(max-width: 819px) 100vw, 819px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000\">Example 2<\/span><\/strong><\/p>\n<p>Here, we will be<strong> using the optional argument &#8211; sum_range<\/strong> as well. The sum_range argument is used when you want to <strong>sum values from a different range than the one used for the criteria<\/strong>. If your criteria are based on one column, but you want to sum values from a different column, you would use the sum_range argument.<\/p>\n<p>For <strong>example<\/strong>, if you have a <strong>list of products in column A<\/strong> and their corresponding <strong>sales amounts in column C<\/strong>, and you want to<strong> sum the sales amounts for a specific product (Product ID &#8211; 1001)<\/strong>, you would use the sum_range argument to specify column C as the range to sum from.<\/p>\n<p>Follow the step-by-step tutorial below &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span> <\/strong>Enter the\u00a0<strong>SUMIF<\/strong>\u00a0function in cell F3.<\/p>\n<p><strong>=SUMIF<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29683\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-1.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"823\" height=\"671\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-1.png 823w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-1-300x245.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-1-768x626.png 768w\" sizes=\"(max-width: 823px) 100vw, 823px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span> <\/strong>Enter the first argument \u2013 <strong>range<\/strong>. Here we have selected the range A2:A89 as it contains all the product IDs.<\/p>\n<p><strong>=SUMIF(A2:A89,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29684\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-2.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"830\" height=\"671\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-2.png 830w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-2-300x243.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-2-768x621.png 768w\" sizes=\"(max-width: 830px) 100vw, 830px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span> <\/strong>Enter the second argument \u2013 <strong>criteria. <\/strong>Here we have entered \u201c1001\u201d as we want the sum of sales for product ID 1001.<\/p>\n<p><strong>=SUMIF(A2:A89,&#8221;1001&#8243;,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29685\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-3.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"827\" height=\"673\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-3.png 827w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-3-300x244.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-3-768x625.png 768w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4: <\/span><\/strong>Enter the third argument \u2013 <strong>sum_range. <\/strong>Here we have selected the C2:C89 range as it contains all the sales amount.<\/p>\n<p><strong>=SUMIF(A2:A89,&#8221;1001&#8243;,C2:C89)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-29686\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-4.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"824\" height=\"670\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-4.png 824w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-4-300x244.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-4-768x624.png 768w\" sizes=\"(max-width: 824px) 100vw, 824px\" \/><\/a><\/p>\n<p>The SUMIF function calculates and provides the sum of sales for product 1001.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29687 size-full\" title=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-5.png\" alt=\"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples\" width=\"827\" height=\"665\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-5.png 827w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-5-300x241.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/06\/SUMIF-Excel-5-768x618.png 768w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"4\" style=\"color: #ff0000!important\">Restrictions of using SUMIF<\/span><\/strong><\/p>\n<p>Even though the SUMIF function is extremely useful, it has some restrictions that you should be aware of:<\/p>\n<ul>\n<li><strong>Range size:<\/strong> The SUMIF function may not be appropriate for some complicated data analysis scenarios since it can become slow or cumbersome when employed with very big data sets.<\/li>\n<li><strong>Syntax difficulty:<\/strong> Using the SUMIF function might be challenging, especially if you\u2019re juggling intricate data sets. To utilize it properly, one must have a thorough understanding of Excel\u2019s features and syntax.<\/li>\n<li>The <strong>size of each range must be uniform<\/strong>. A #VALUE error will be returned if the supplied ranges don\u2019t match.<\/li>\n<li>All <strong>range arguments must be actual ranges<\/strong>; an array cannot be used with the SUMIF function.<\/li>\n<li>SUMIF is <strong>not case-sensitive<\/strong>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000\">Conclusion<\/span><\/strong><\/p>\n<p>The article introduces the SUMIF function in Excel, which is used to sum values in a range based on specific criteria. It explains the syntax of the function, consisting of the range, criteria, and optional sum_range arguments. It also provides two examples demonstrating how to use SUMIF in Excel. It also highlights some restrictions on using this function.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel, a widely-used spreadsheet software, offers a multitude of powerful features for managing and analyzing data. One such feature that proves to be extremely useful is SUMIF. The SUMIF in Excel enables you to sum values in a range that satisfies a condition. In this article, we will be covering the following topics in detail [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":29745,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"A Quick Guide to Using the SUMIF in Excel - 2 Helpful Examples","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15,291],"tags":[1270,57,1271,1269,1268],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/29676"}],"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=29676"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/29676\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/29745"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=29676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=29676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=29676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}