SUMIFS Function in Excel: Syntax, Examples and Free Practice
SUMIFS is an Excel Math & Trig function. Like SUMIF but can check multiple conditions at once.
SUMIFS syntax
Arguments
sum_range: The range to sum, if different from the range being checkedcriteria_range1: The first range to check against a conditioncriteria1: The first condition to match
When to use SUMIFS
SUMIFS is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice SUMIFS online, free
Open the live Excel-style spreadsheet and try SUMIFS yourself. No Excel install or sign-up needed to start.
Practice SUMIFS now →Watch: SUMIFS in Excel
Learn more
Read the tutorial: SUMIFS with multiple criteria.
More Math & Trig functions
Frequently asked questions
What does the SUMIFS function do in Excel?
Like SUMIF but can check multiple conditions at once.
What is the syntax of SUMIFS in Excel?
The syntax is =SUMIFS(sum_range, criteria_range1, criteria1, ...). sum_range: The range to sum, if different from the range being checked; criteria_range1: The first range to check against a condition; criteria1: The first condition to match.
Where can I practice SUMIFS online for free?
Open the free live spreadsheet on Cellgrids and try SUMIFS 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