Excel practice · Conditional Counting & Averages

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

  1. Count shipped West region orders
  2. Count large late orders
  3. Count senior engineers
  4. Count in-stock electronics
  5. Count strong email campaigns

The exercises

1. Count shipped West region orders Medium

Count how many orders are both from the West region AND already Shipped.

ABCDE
1RegionStatusRegion:West
2WestShippedStatus:Shipped
3EastShippedCount:?
4WestPending
5WestShipped
6EastPending

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.

2. Count large late orders Medium

Count how many orders are marked Late AND worth $200 or more.

ABCDE
1StatusValueCount:?
2Late250
3On Time300
4Late120
5Late210
6On Time90

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.

3. Count senior engineers Medium

Count how many people are in the Engineering department AND at the Senior level.

ABCDE
1DepartmentLevelDept:Engineering
2EngineeringSeniorLevel:Senior
3EngineeringJuniorCount:?
4SalesSenior
5EngineeringSenior
6EngineeringJunior
7EngineeringMid

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.

4. Count in-stock electronics Medium

Count how many products are in the Electronics category AND still have stock.

ABCDE
1CategoryStockCount:?
2Electronics5
3Electronics0
4Furniture3
5Electronics2
6Furniture0

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.

5. Count strong email campaigns Medium

Count how many campaigns ran on the Email channel AND got 100 or more clicks.

ABCDE
1ChannelClicksCount:?
2Email140
3Social220
4Email60
5Email110
6Social90

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 →

More conditional counting & averages practice

All Excel practice exercises · Excel test prep