COUNTIF practice exercises
5 graded problems with realistic data, all medium.
Counts how many cells in a range meet one condition. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the COUNTIF guide first: syntax, a worked example and the mistakes people make.
In this set
- Count the top scorers
- Count late deliveries
- Count products low on stock
- Count strong attendance days
- Count the mystery novels
The exercises
How many students scored above 90 on the final?
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Lea | 92 |
| 3 | Noah | 76 |
| 4 | Ines | 95 |
| 5 | Marco | 60 |
| 6 | Priya | 91 |
| 7 | Above 90 | ? |
Enter a formula in B7.
Show a hint
COUNTIF(range, criteria). The criteria can be a comparison, like =COUNTIF(B2:B6,">90").
COUNTIF turns a long list into an instant headcount: how many late, how many passed, how many in stock.
This week's delivery log marks each order's status. Count how many were marked 'Late'.
| A | B | |
|---|---|---|
| 1 | Order | Status |
| 2 | #101 | On Time |
| 3 | #102 | Late |
| 4 | #103 | On Time |
| 5 | #104 | Late |
| 6 | #105 | Late |
| 7 | Late Count | ? |
Enter a formula in B7.
Show a hint
An exact text match works without an operator: =COUNTIF(B2:B6,"Late").
Status counts like this are the bread and butter of any ops or logistics tracker.
The stockroom sheet lists units left for each product. Count how many have fewer than 10 units left.
| A | B | |
|---|---|---|
| 1 | Product | Units Left |
| 2 | Mugs | 4 |
| 3 | Notebooks | 22 |
| 4 | Stickers | 8 |
| 5 | Pens | 15 |
| 6 | Folders | 11 |
| 7 | Low Stock | ? |
Enter a formula in B7.
Show a hint
=COUNTIF(B2:B6,"<10").
Low-stock alerts are just a COUNTIF (or an IF on top of one) watching a threshold.
Attendance was logged for each club meeting this month. Count how many meetings had 15 or more attendees.
| A | B | |
|---|---|---|
| 1 | Meeting | Attendees |
| 2 | 1 | 12 |
| 3 | 2 | 18 |
| 4 | 3 | 9 |
| 5 | 4 | 20 |
| 6 | 5 | 8 |
| 7 | Strong Days | ? |
Enter a formula in B7.
Show a hint
=COUNTIF(B2:B6,">=15").
Counting how often a metric clears a bar is the same COUNTIF pattern as any attendance or quality report.
The book club's reading list tracks each title's genre. Count how many are Mystery.
| A | B | |
|---|---|---|
| 1 | Title | Genre |
| 2 | Book A | Mystery |
| 3 | Book B | Drama |
| 4 | Book C | Mystery |
| 5 | Book D | Sci-Fi |
| 6 | Book E | Mystery |
| 7 | Mystery Count | ? |
Enter a formula in B7.
Show a hint
=COUNTIF(B2:B6,"Mystery"). COUNTIF's text matching is case-insensitive.
Counting entries by category is how COUNTIF shows up outside of pure numbers.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the COUNTIF exercises →