COUNTIFS practice exercises
5 graded problems with realistic data, all medium.
Counts rows that satisfy every one of several conditions at once. 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 COUNTIFS guide first: syntax, a worked example and the mistakes people make.
In this set
- Count shipped West region orders
- Count large late orders
- Count senior engineers
- Count in-stock electronics
- Count strong email campaigns
The exercises
Count how many orders are both from the West region AND already Shipped.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Status | Region: | West | |
| 2 | West | Shipped | Status: | Shipped | |
| 3 | East | Shipped | Count: | ? | |
| 4 | West | Pending | |||
| 5 | West | Shipped | |||
| 6 | East | Pending |
Enter a formula in E3.
Show a hint
COUNTIFS(range1, criteria1, range2, criteria2). No separate sum range needed, just condition pairs: =COUNTIFS(A2:A6,E1,B2:B6,E2).
COUNTIFS is COUNTIF with more than one filter: how many rows match ALL of these conditions at once.
Count how many orders are marked Late AND worth $200 or more.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Status | Value | Count: | ? | |
| 2 | Late | 250 | |||
| 3 | On Time | 300 | |||
| 4 | Late | 120 | |||
| 5 | Late | 210 | |||
| 6 | On Time | 90 |
Enter a formula in E1.
Show a hint
=COUNTIFS(A2:A6,"Late",B2:B6,">=200").
Flagging "big AND late" orders is a classic ops question. One condition alone (just late, or just big) would give the wrong headcount.
Count how many people are in the Engineering department AND at the Senior level.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Department | Level | Dept: | Engineering | |
| 2 | Engineering | Senior | Level: | Senior | |
| 3 | Engineering | Junior | Count: | ? | |
| 4 | Sales | Senior | |||
| 5 | Engineering | Senior | |||
| 6 | Engineering | Junior | |||
| 7 | Engineering | Mid |
Enter a formula in E3.
Show a hint
=COUNTIFS(A2:A7,E1,B2:B7,E2).
Headcount by department and level is a standard HR report, and exactly the two-condition COUNTIFS pattern.
Count how many products are in the Electronics category AND still have stock.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Category | Stock | Count: | ? | |
| 2 | Electronics | 5 | |||
| 3 | Electronics | 0 | |||
| 4 | Furniture | 3 | |||
| 5 | Electronics | 2 | |||
| 6 | Furniture | 0 |
Enter a formula in E1.
Show a hint
=COUNTIFS(A2:A6,"Electronics",B2:B6,">0").
This is the same pattern behind a real "what do we need to reorder, by category" report.
Count how many campaigns ran on the Email channel AND got 100 or more clicks.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Channel | Clicks | Count: | ? | |
| 2 | 140 | ||||
| 3 | Social | 220 | |||
| 4 | 60 | ||||
| 5 | 110 | ||||
| 6 | Social | 90 |
Enter a formula in E1.
Show a hint
=COUNTIFS(A2:A6,"Email",B2:B6,">=100").
Marketing reports filter by channel and a performance threshold constantly. This is that, in one formula.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the COUNTIFS exercises →