COUNTIFS
Count rows that meet several conditions at once
0 of 3 done · Lesson 7 of 18
Understand
One condition was enough until the question got sharper. Now it is how many Otago orders came in during January. COUNTIFS takes as many range and condition pairs as you need, and a row is only counted when every one of them holds.
=COUNTIFS(first column to check, first condition, next column, optional, next condition, optional)
A worked example
=COUNTIFS(C2:C9, "Otago", E2:E9, "Feb")
first column to checkfirst conditionnext columnnext condition
This returns 1
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 |