COUNTIF
Count only the rows that meet a condition
0 of 3 done · Lesson 5 of 18
Understand
COUNT tells you how many orders there are. Nobody ever wants that on its own. They want how many came from Otago, or how many cleared a thousand dollars. COUNTIF is COUNT with the question attached.
=COUNTIF(where to look, what counts)
A worked example
=COUNTIF(C2:C9, "Waikato")
where to lookwhat counts
This returns 2
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 |