SUMIFS
Add up rows that meet several conditions at once
0 of 3 done · Lesson 8 of 18
Understand
This is the one that ends up in every monthly report: how much did Otago bring in during January. SUMIFS looks like SUMIF with more pairs, except for one thing that trips up everybody who learned SUMIF first.
=SUMIFS(what to add up, first column to check, first condition, next column, optional, next condition, optional)
A worked example
=SUMIFS(D2:D9, C2:C9, "Waikato", E2:E9, "Jan")
what to add upfirst column to checkfirst conditionnext columnnext condition
This returns 2,620
The sheet you are working with
| Row number | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Order | Customer | Region | Amount | Month |
| 2 | 1042 | Northwind | Otago | 1250 | Jan |
| 3 | 1043 | Kea Ltd | Waikato | 840 | Jan |
| 4 | 1044 | Halcyon | Otago | 2110 | Feb |
| 5 | 1045 | Brightsmith | Auckland | 560 | Feb |
| 6 | 1046 | Tuatara | Waikato | 1780 | Jan |
| 7 | 1047 | Fernway | Otago | 930 | Mar |
| 8 | 1048 | Pounamu | Nelson | 1420 | Feb |
| 9 | 1049 | Rimu Co | Otago | 1120 | Jan |