COUNTIF practice exercises
Counts cells that match a condition. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 7301 | East | Kofi | 8 | 60 | 480 |
| 3 | 7302 | West | Omar | 3 | 24 | 72 |
| 4 | 7303 | East | Ines | 3 | 30 | 90 |
| 5 | 7304 | North | Raj | 9 | 30 | 270 |
| 6 | 7305 | South | Raj | 5 | 18 | 90 |
| 7 | 7306 | North | Ines | 7 | 12 | 84 |
| 8 | 7307 | West | Omar | 2 | 15 | 30 |
| 9 | 7308 | South | Omar | 2 | 24 | 48 |
How many orders came from North?
Show answer
=COUNTIF(B2:B9,"North")→ 2How many orders sold more than 5 units?
Show answer
=COUNTIF(D2:D9,">5")→ 3How many orders sold more than 3 units?
Show answer
=COUNTIF(D2:D9,">3")→ 4How many orders sold more than 6 units?
Show answer
=COUNTIF(D2:D9,">6")→ 3How many orders came from East?
Show answer
=COUNTIF(B2:B9,"East")→ 2How many orders came from South?
Show answer
=COUNTIF(B2:B9,"South")→ 2
New to COUNTIF? Read the COUNTIF guide first: syntax, a worked example and common mistakes.