IntermediateMath Functions
Total sales for a region and month with SUMIFS
Apply two conditions at once to a conditional sum.
SUMIFS
9 min25 points
SUMIFS
Adds up values that meet several conditions at once.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, ...)
Math Functions.
A worked example
=SUMIFS(B2:B9,C2:C9,"East",D2:D9,"Oct")
Returns 9,325
Totals October orders from the East region only.
Where it goes wrong
SUMIFS reverses SUMIF's argument order — the sum range comes FIRST. Getting this backwards is the single most common mistake with it.
Practise SUMIFS
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All SUMIFS practice exercises →