SUMIF
Add up only the rows that meet a condition
0 of 3 done · Lesson 6 of 18
Understand
Counting Otago orders was useful. What the regional manager actually wants is how much money came from Otago. SUMIF checks one column and adds up a different one, which is the part people get tangled in.
=SUMIF(where to check, what counts, what to add up, optional)
A worked example
=SUMIF(C2:C9, "Waikato", D2:D9)
where to checkwhat countswhat to add up
This returns 2,620
The sheet you are working with
| Row number | A | B | C | D |
|---|---|---|---|---|
| 1 | Order | Customer | Region | Amount |
| 2 | 1042 | Northwind | Otago | 1250 |
| 3 | 1043 | Kea Ltd | Waikato | 840 |
| 4 | 1044 | Halcyon | Otago | 2110 |
| 5 | 1045 | Brightsmith | Auckland | 560 |
| 6 | 1046 | Tuatara | Waikato | 1780 |
| 7 | 1047 | Fernway | Otago | 930 |
| 8 | 1048 | Pounamu | Nelson | 1420 |
| 9 | 1049 | Rimu Co | Otago | 1120 |