{"id":16200,"date":"2023-08-24T16:42:56","date_gmt":"2023-08-24T16:42:56","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=16200"},"modified":"2024-02-19T14:52:06","modified_gmt":"2024-02-19T14:52:06","slug":"excel-sumif-with-index-match","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/","title":{"rendered":"Excel SUMIF with INDEX &amp; MATCH"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-66330ed2-f9b8-4fa3-adb6-81131af4e30e\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/Excel-SUMIF-with-INDEX-MATCH.xlsx\">Excel-SUMIF-with-INDEX-MATCH<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/Excel-SUMIF-with-INDEX-MATCH.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-66330ed2-f9b8-4fa3-adb6-81131af4e30e\">Download File<\/a><\/div>\n\n\n\n<p>Although Excel formulas are powerful as a standalone option, their true power can be seen when combined. <strong>INDEX and MATCH<\/strong> are two formulas that usually go hand-in-hand. However, we can add even more formulas to the equation.<\/p>\n\n\n\n<p>In the example below, we will show how to use these <strong>two formulas with the SUMIF formula<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Standalone Formulas<\/h2>\n\n\n\n<p>For our example, we will presume that we have a <strong>sales data table<\/strong>. The data will be constructed in the following way: <strong>Product Name will be in Column A, Sales Amount will be in Column B, and Date will be in Column C<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"367\" height=\"220\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png\" alt=\"\" class=\"wp-image-16201\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png 367w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1-300x180.png 300w\" sizes=\"(max-width: 367px) 100vw, 367px\" \/><\/figure>\n\n\n\n<p>In case we want to sum all the sales of a certain product, for example, <strong>product C<\/strong>, we could use the <strong>SUMIF formula<\/strong> to achieve it. We will insert the formula in <strong>cell F2<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUMIF(A2:A8,\"Product C\",B2:B8)<\/code><\/pre>\n\n\n\n<p>This formula has three parameters: <strong>range, criteria, and sum_range<\/strong>. Our <strong>range is A2:28<\/strong>, the <strong>criteria is<\/strong> <strong>Product C<\/strong>, and the <strong>sum_range will be the data in range B2:B8<\/strong>.<\/p>\n\n\n\n<p>Once we insert the formula, the result will be as follows:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"576\" height=\"276\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-2.png\" alt=\"\" class=\"wp-image-16202\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-2.png 576w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-2-300x144.png 300w\" sizes=\"(max-width: 576px) 100vw, 576px\" \/><\/figure>\n\n\n\n<p>The <strong>result will<\/strong> <strong>be $384,520<\/strong>, which is the <strong>sum of cells B5 and B7<\/strong>, where product C is located.<\/p>\n\n\n\n<p><strong>INDEX and MATCH<\/strong> is a more dynamic formula, but if we want to use it for similar purposes, it will not be possible, as this formula searches for the first value in our table. If we put the value <strong>Product B in cell D3<\/strong>, we will insert the following formula in <strong>cell E3<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=INDEX(B2:B8, MATCH(D3, A2:A8, 0))<\/code><\/pre>\n\n\n\n<p>This formula will only find the first value that is equal to <strong>Product B <\/strong>in our table, which will result in the <strong>number of $170,860<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"270\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-3.png\" alt=\"\" class=\"wp-image-16203\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-3.png 609w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-3-300x133.png 300w\" sizes=\"(max-width: 609px) 100vw, 609px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">SUMIF, INDEX, and MATCH Combined<\/h2>\n\n\n\n<p>To show the full capacity of these formulas combined, we will create another table, one that will show the <strong>profit and loss for a certain company<\/strong>, with the <strong>revenues and expenses that will be categorized<\/strong>. The data will show the <strong>monthly result from every category, ranging from January to June<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"964\" height=\"244\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-4.png\" alt=\"\" class=\"wp-image-16204\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-4.png 964w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-4-300x76.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-4-768x194.png 768w\" sizes=\"(max-width: 964px) 100vw, 964px\" \/><\/figure>\n\n\n\n<p>In the table below, we will extract <strong>three categories that we have: revenue, operating expenses, and other expenses<\/strong>, line them up in <strong>three rows, and we will use three months: February, March, and June<\/strong> (these will be in different columns):<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"568\" height=\"109\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-5.png\" alt=\"\" class=\"wp-image-16205\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-5.png 568w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-5-300x58.png 300w\" sizes=\"(max-width: 568px) 100vw, 568px\" \/><\/figure>\n\n\n\n<p>We can insert only one formula to get all the results we need. The formula in <strong>cell B13<\/strong>, which is the result for <strong>February Revenue<\/strong> will be:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SUMIF($B$1:$B$9,$A13,INDEX($C$1:$H$9,0,MATCH(B$12,$C$1:$H$1,0)))<\/code><\/pre>\n\n\n\n<p>And the result will be <strong>number $147,168.<\/strong><\/p>\n\n\n\n<p>We will drag this formula in empty cells, and will get the <strong>following result<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"966\" height=\"430\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-6.png\" alt=\"\" class=\"wp-image-16206\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-6.png 966w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-6-300x134.png 300w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-6-768x342.png 768w\" sizes=\"(max-width: 966px) 100vw, 966px\" \/><\/figure>\n\n\n\n<p>This formula is based on <strong>SUMIF<\/strong>. The components are:<\/p>\n\n\n\n<ul>\n<li><strong>Range:<\/strong> The range will be the data in <strong>column B (B1:B9)<\/strong>, and we will <strong>lock this table, as we will always look within these values<\/strong>.<\/li>\n\n\n\n<li><strong>Criteria:<\/strong> Our <strong>search criteria<\/strong> will be in <strong>column A<\/strong>, and we will <strong>lock the column value<\/strong>, and change the rows as we go. This way, search criteria will <strong>vary from Revenue to Operating Expenses<\/strong>, and finally to <strong>Other Expenses<\/strong>.<\/li>\n\n\n\n<li>For the <strong>sum_range<\/strong>, we will use the data from <strong>range C1:H9,<\/strong> but we will do this through <strong>INDEX and MATCH<\/strong>, to retrieve only the values from a certain month. In the <strong>INDEX and MATCH formula<\/strong>, the values are:\n<ul>\n<li><strong>Range C1:H9<\/strong> is used as an <strong>array<\/strong>;<\/li>\n\n\n\n<li>We put in <strong>0 as a row number<\/strong>, as we already have a <strong>row value found in revenue<\/strong>;<\/li>\n\n\n\n<li>For the <strong>column number<\/strong>, we use the <strong>MATCH formula<\/strong>, for which we use the value in <strong>row 12 as a lookup_value (the<\/strong> <strong>row value will be locked<\/strong>, but the <strong>columns will change from February to March, and finally to June)<\/strong>. <strong>Lookup_array will be range C1:H1<\/strong>, as we want to find the values in this range.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p>Combined, these formulas can give us excellent flexibility and an overview of the table, no matter how complex it is. Our <strong>example might be a little simplified<\/strong>, but the same formula can be applied to a <strong>larger set of data<\/strong>. Combined, these formulas can give us a nice flexibility and overview of the table, no matter how complex it is. Our example might be a little simplified, but the same formula can be applied to a larger set of data.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Although Excel formulas are powerful as a standalone option, their true power can be seen when combined. INDEX and MATCH are two formulas&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel SUMIF with INDEX &amp; MATCH<\/title>\n<meta name=\"description\" content=\"Learn how to use the powerful combination of INDEX, MATCH, and SUMIF formulas in Excel to sum sales data for specific products. Download the file now.\" \/>\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\/formulas\/excel-sumif-with-index-match\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel SUMIF with INDEX &amp; MATCH\" \/>\n<meta property=\"og:description\" content=\"Learn how to use the powerful combination of INDEX, MATCH, and SUMIF formulas in Excel to sum sales data for specific products. Download the file now.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-24T16:42:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:52:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Excel SUMIF with INDEX &amp; MATCH\",\"datePublished\":\"2023-08-24T16:42:56+00:00\",\"dateModified\":\"2024-02-19T14:52:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/\"},\"wordCount\":697,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png\",\"keywords\":[\"file\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/\",\"name\":\"Excel SUMIF with INDEX &amp; MATCH\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png\",\"datePublished\":\"2023-08-24T16:42:56+00:00\",\"dateModified\":\"2024-02-19T14:52:06+00:00\",\"description\":\"Learn how to use the powerful combination of INDEX, MATCH, and SUMIF formulas in Excel to sum sales data for specific products. Download the file now.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png\",\"width\":367,\"height\":220},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel SUMIF with INDEX &amp; MATCH\"}]},{\"@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.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel SUMIF with INDEX &amp; MATCH","description":"Learn how to use the powerful combination of INDEX, MATCH, and SUMIF formulas in Excel to sum sales data for specific products. Download the file now.","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\/formulas\/excel-sumif-with-index-match\/","og_locale":"en_US","og_type":"article","og_title":"Excel SUMIF with INDEX &amp; MATCH","og_description":"Learn how to use the powerful combination of INDEX, MATCH, and SUMIF formulas in Excel to sum sales data for specific products. Download the file now.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/","article_published_time":"2023-08-24T16:42:56+00:00","article_modified_time":"2024-02-19T14:52:06+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Excel SUMIF with INDEX &amp; MATCH","datePublished":"2023-08-24T16:42:56+00:00","dateModified":"2024-02-19T14:52:06+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/"},"wordCount":697,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png","keywords":["file"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/","url":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/","name":"Excel SUMIF with INDEX &amp; MATCH","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png","datePublished":"2023-08-24T16:42:56+00:00","dateModified":"2024-02-19T14:52:06+00:00","description":"Learn how to use the powerful combination of INDEX, MATCH, and SUMIF formulas in Excel to sum sales data for specific products. Download the file now.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/08\/word-image-16200-1.png","width":367,"height":220},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/excel-sumif-with-index-match\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel SUMIF with INDEX &amp; MATCH"}]},{"@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."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16200"}],"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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=16200"}],"version-history":[{"count":1,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16200\/revisions"}],"predecessor-version":[{"id":16208,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16200\/revisions\/16208"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=16200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=16200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=16200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}