Excel practice · Conditional Counting & Averages

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

  1. Count the top scorers
  2. Count late deliveries
  3. Count products low on stock
  4. Count strong attendance days
  5. Count the mystery novels

The exercises

1. Count the top scorers Medium

How many students scored above 90 on the final?

AB
1StudentScore
2Lea92
3Noah76
4Ines95
5Marco60
6Priya91
7Above 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.

2. Count late deliveries Medium

This week's delivery log marks each order's status. Count how many were marked 'Late'.

AB
1OrderStatus
2#101On Time
3#102Late
4#103On Time
5#104Late
6#105Late
7Late 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.

3. Count products low on stock Medium

The stockroom sheet lists units left for each product. Count how many have fewer than 10 units left.

AB
1ProductUnits Left
2Mugs4
3Notebooks22
4Stickers8
5Pens15
6Folders11
7Low 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.

4. Count strong attendance days Medium

Attendance was logged for each club meeting this month. Count how many meetings had 15 or more attendees.

AB
1MeetingAttendees
2112
3218
439
5420
658
7Strong 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.

5. Count the mystery novels Medium

The book club's reading list tracks each title's genre. Count how many are Mystery.

AB
1TitleGenre
2Book AMystery
3Book BDrama
4Book CMystery
5Book DSci-Fi
6Book EMystery
7Mystery 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 →

More conditional counting & averages practice

All Excel practice exercises · Excel test prep