COUNTIFS practice exercises
Counts rows that match every 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 | 5201 | East | Maya | 4 | 30 | 120 |
| 3 | 5202 | East | Raj | 1 | 45 | 45 |
| 4 | 5203 | East | Theo | 6 | 24 | 144 |
| 5 | 5204 | South | Raj | 6 | 24 | 144 |
| 6 | 5205 | South | Raj | 1 | 30 | 30 |
| 7 | 5206 | North | Maya | 7 | 45 | 315 |
| 8 | 5207 | North | Theo | 2 | 60 | 120 |
| 9 | 5208 | West | Ana | 2 | 24 | 48 |
Count East orders with more than 1 units.
Show answer
=COUNTIFS(B2:B9,"East",D2:D9,">1")→ 2Count South orders with more than 1 units.
Show answer
=COUNTIFS(B2:B9,"South",D2:D9,">1")→ 1Count North orders with more than 4 units.
Show answer
=COUNTIFS(B2:B9,"North",D2:D9,">4")→ 1Count South orders with more than 5 units.
Show answer
=COUNTIFS(B2:B9,"South",D2:D9,">5")→ 1Count East orders with more than 3 units.
Show answer
=COUNTIFS(B2:B9,"East",D2:D9,">3")→ 2Count East orders with more than 2 units.
Show answer
=COUNTIFS(B2:B9,"East",D2:D9,">2")→ 2
New to COUNTIFS? Read the COUNTIFS guide first: syntax, a worked example and common mistakes.