BeginnerMath Functions
Total sales for one region with SUMIF
Add up only the rows matching a text condition.
SUMIF
6 min15 points
SUMIF
Adds up only the values that meet one condition.
Syntax
SUMIF(range, criteria, [sum_range])
Math Functions.
A worked example
=SUMIF(D2:D9,"West",C2:C9)
Returns 3,815
Adds the values in column C for rows where column D says West.
Where it goes wrong
The argument order trips people up: the range you search comes first, the range you add comes last. With only two arguments it adds up the range it searched.
Practise SUMIF
Knowing what a function does and being able to write it from memory are different skills. These close the gap.