SUMIF using an INDEX+MATCH range Function in Excel: Syntax, Examples and Free Practice
SUMIF using an INDEX+MATCH range is an Excel Math & Trig function. Uses INDEX+MATCH to dynamically select which column SUMIF should even look at, instead of a fixed range.
SUMIF using an INDEX+MATCH range syntax
Arguments
data: The full data tablecategory: Which column to targetcriteria: Value to match within that column
When to use SUMIF using an INDEX+MATCH range
Summing a specific product's sales without rewriting the formula every time the report layout changes.
Practice SUMIF using an INDEX+MATCH range online, free
Open the live Excel-style spreadsheet and try SUMIF using an INDEX+MATCH range yourself. No Excel install or sign-up needed to start.
Practice SUMIF using an INDEX+MATCH range now →More Math & Trig functions
Frequently asked questions
What does the SUMIF using an INDEX+MATCH range function do in Excel?
Uses INDEX+MATCH to dynamically select which column SUMIF should even look at, instead of a fixed range.
What is the syntax of SUMIF using an INDEX+MATCH range in Excel?
The syntax is =SUMIF(INDEX(data,0,MATCH(category,headers,0)), criteria, value_range). data: The full data table; category: Which column to target; criteria: Value to match within that column.
Where can I practice SUMIF using an INDEX+MATCH range online for free?
Open the free live spreadsheet on Cellgrids and try SUMIF using an INDEX+MATCH range yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts