{"id":1450,"date":"2018-07-04T15:00:39","date_gmt":"2018-07-04T15:00:39","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1450"},"modified":"2023-11-03T14:38:29","modified_gmt":"2023-11-03T14:38:29","slug":"sumifs","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/","title":{"rendered":"SUMIFS function"},"content":{"rendered":"\n

Excel SUMIFS Function is a powerful tool for adding up numbers in a range that meets multiple criteria. It’s like a filter that selects specific data and then adds up only the values that match those criteria. Let’s break down how to use this function step by step.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

SUMIFS(range, criteria_range1, criteria1, [criteria_range2, criteria2], …)<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
range<\/strong><\/td>The range of numbers you want to sum based on the given criteria.<\/td><\/tr>
criteria_range1<\/strong><\/td>The first range where you want to apply a condition.<\/td><\/tr>
criteria1<\/strong><\/td>The condition you want to apply to the first range.<\/td><\/tr>
[criteria_range2, criteria2]<\/strong><\/td>(Optional) Additional ranges and criteria you want to apply. You can have multiple pairs of criteria_range and criteria.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to use<\/h2>\n\n\n\n

Let’s see how to use the SUMIFS function with some examples:<\/p>\n\n\n\n

Suppose you have a table of sales data with two columns: “Product” and “Sales.” You want to find the total sales for a specific product, for instance, “Apples.”<\/p>\n\n\n\n

=SUMIFS(B2:B10, A2:A10, \"Apples\")<\/code><\/pre>\n\n\n\n
This formula adds up all the sales in the “Sales” column where the corresponding “Product” column matches “Apples.”<\/p>\n\n\n\n
If you want to find the total sales for “Apples” and “Oranges,” you can use multiple criteria:<\/p>\n\n\n\n
=SUMIFS(B2:B10, A2:A10, \"Apples\", A2:A10, \"Oranges\")<\/code><\/pre>\n\n\n\n
The formula sums the sales for both “Apples” and “Oranges” from the “Sales” column.<\/p>\n\n\n\n
If you need to apply different criteria for two different ranges, you can do that as well. For example, to find the total sales for “Apples” in January and “Oranges” in February:<\/p>\n\n\n\n
=SUMIFS(B2:B10, A2:A10, \"Apples\", C2:C10, \"January\", A2:A10, \"Oranges\", C2:C10, \"February\")<\/code><\/pre>\n\n\n\n
By using multiple pairs of criteria_range and criteria, you can perform more complex analyses on your data.<\/p>\n\n\n\n
Summary<\/h2>\n\n\n\n
Excel SUMIFS Function is a versatile way to sum values that meet specific criteria. You can use it to filter and calculate the sum based on various conditions, making it a valuable tool for data analysis and reporting.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel SUMIFS Function is a powerful tool for adding up numbers in a range that meets multiple criteria. It’s like a filter that…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nSUMIFS function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SUMIFS function\" \/>\n<meta property=\"og:description\" content=\"Excel SUMIFS Function is a powerful tool for adding up numbers in a range that meets multiple criteria. It’s like a filter that...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T15:00:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T14:38:29+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"SUMIFS function\",\"datePublished\":\"2018-07-04T15:00:39+00:00\",\"dateModified\":\"2023-11-03T14:38:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/\"},\"wordCount\":302,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/\",\"name\":\"SUMIFS function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T15:00:39+00:00\",\"dateModified\":\"2023-11-03T14:38:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/sumifs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SUMIFS function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SUMIFS function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/","og_locale":"en_US","og_type":"article","og_title":"SUMIFS function","og_description":"Excel SUMIFS Function is a powerful tool for adding up numbers in a range that meets multiple criteria. It’s like a filter that...","og_url":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/","article_published_time":"2018-07-04T15:00:39+00:00","article_modified_time":"2023-11-03T14:38:29+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"SUMIFS function","datePublished":"2018-07-04T15:00:39+00:00","dateModified":"2023-11-03T14:38:29+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/"},"wordCount":302,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/","url":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/","name":"SUMIFS function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T15:00:39+00:00","dateModified":"2023-11-03T14:38:29+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/sumifs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/sumifs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"SUMIFS function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1450"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1450"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1450\/revisions"}],"predecessor-version":[{"id":16600,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1450\/revisions\/16600"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}