{"id":345,"date":"2023-08-17T06:27:48","date_gmt":"2023-08-17T06:27:48","guid":{"rendered":"https:\/\/sheeter.ai\/blog\/?p=345"},"modified":"2023-08-18T07:26:28","modified_gmt":"2023-08-18T07:26:28","slug":"how-to-use-sumif-function","status":"publish","type":"post","link":"https:\/\/sheeter.ai\/blog\/how-to-use-sumif-function\/","title":{"rendered":"How to Use =SUMIF Function in Microsoft Excel &#038; Google Sheets"},"content":{"rendered":"<p>The =SUMIF function is a powerful tool that can help you sum data based on the criteria you specify. And if you&#8217;re having trouble remembering how the function works, you can always refer to this handy guide.<\/p>\n<p>In Excel &amp; Sheets, the =SUMIF function is used to sum data based on a single criterion.<\/p>\n<p>For example, you could use =SUMIF to sum all of the cells in a range that are greater than or equal to a certain value. Or, you could use =SUMIF to sum all of the cells in a range that contain a specific text string.<\/p>\n<p>And in this guide, we&#8217;ll show you how to use the =SUMIF function in both Excel and Google Sheets.<\/p>\n<h2>How to Use =SUMIF Function<\/h2>\n<p>SUMIF is a function that allows you to sum data based on the criteria you specify. For example, you could use the =SUMIF function to sum all of the cells in a range that are greater than 10.<\/p>\n<p>To use the =SUMIF function, simply enter the following into a cell:<\/p>\n<blockquote><p>=SUMIF(range, criteria, sum_range)<\/p><\/blockquote>\n<p>Where:<\/p>\n<ul>\n<li>range &#8211; the cells that you want to evaluate<\/li>\n<li>criteria &#8211; the criterion that must be met for a cell to be included in the sum<\/li>\n<li>sum_range &#8211; the cells that you want to sum if the criterion is met<\/li>\n<\/ul>\n<p>For example, let&#8217;s say we have a list of numbers in cells A1 to A5, and we want to sum all of the numbers that are greater than 10. We could use the following =SUMIF function:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2022\/10\/use-of-sumif-function.png\" alt=\"\" title=\"\"><\/p>\n<blockquote><p>=SUMIF(A1:A5, &#8220;&gt;10&#8221;, A1:A5)<\/p><\/blockquote>\n<p>Which, in our case, would give us a result of 15 ( since only the value in A4 is greater than 10).<\/p>\n<p>You can also use the =SUMIF function to sum cells based on text criteria.<\/p>\n<p>For example, let&#8217;s say we have a list of names in cells A1 to A5, and we want to sum all of the cells that contain the name &#8220;John&#8221;. We could use the following =SUMIF function:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/sheeter.ai\/blog\/wp-content\/uploads\/2022\/10\/sumif-function-use.png\" alt=\"\" title=\"\"><\/p>\n<blockquote><p>=SUMIF(A1:A5, &#8220;*John*&#8221;, B1:B5)<\/p><\/blockquote>\n<p>Which would give us a result of 10 (since only one &#8220;John&#8221; name appears in our list).<\/p>\n<h2>Final Thoughts<\/h2>\n<p>=SUMIF is really helpful when you want to sum data based on a specific criterion. And while it may seem confusing at first, it&#8217;s actually pretty easy to use once you get the hang of it.<\/p>\n<p>We hope this guide has been helpful. If you have any questions, feel free to post them in the comments below.<\/p>\n","protected":false},"excerpt":{"rendered":"\n<p class=\"read-more-container\"><a title=\"How to Use =SUMIF Function in Microsoft Excel &#038; Google Sheets\" href=\"https:\/\/sheeter.ai\/blog\/how-to-use-sumif-function\/\" aria-label=\"More on How to Use =SUMIF Function in Microsoft Excel &#038; Google Sheets\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":42,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-345","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33","no-featured-image-padding"],"_links":{"self":[{"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/posts\/345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/comments?post=345"}],"version-history":[{"count":0,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/posts\/345\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/media\/42"}],"wp:attachment":[{"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/media?parent=345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/categories?post=345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheeter.ai\/blog\/wp-json\/wp\/v2\/tags?post=345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}