Summing Across Conditions With SUMIFS
Total values that meet several criteria at the same time.
When One Condition Isn't Enough
You already know SUMIF totals values that match a single rule, like all sales from the East region. But real questions are usually layered: What were East region sales in January? That's two conditions at once.
This is where SUMIFS shines. The trailing S means it can stack many criteria together, and a row is only added to the total when it passes every test you give it.
In this lesson you'll learn the argument order, write your first multi-criteria sum, and avoid the classic mistakes that trip people up.
The SUMIFS Argument Order
SUMIFS flips the order you might expect from SUMIF. The numbers you add come first, then each condition is given as a pair.
sum_range— the values to totalcriteria_range1,criteria1— the first testcriteria_range2,criteria2— the second test
You can keep adding range and criteria pairs up to 127 conditions. Read the pattern below out loud: sum this, where this equals that, and where this equals that.
=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2)All lessons in this course
- Summing Across Conditions With SUMIFS
- Counting Across Conditions With COUNTIFS
- Averaging Across Conditions With AVERAGEIFS
- Date Ranges in Criteria Functions