Level 2Multi-Condition MathPractice, 3 min
COUNTIFS: big deals in one region
The task
How many deals of at least the amount in H2 did the region in H1 close? In H3, use
COUNTIFS, and point at H2 for the threshold instead of typing 5000.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Rep | Region | Product | Closed | Amount | Region | East | |
| 2 | Maya | West | Pro | Apr 3, 2026 | $4,800 | At least | $5,000 | |
| 3 | Theo | East | Starter | Apr 7, 2026 | $1,200 | Deals | ||
| 4 | Priya | Central | Pro | Apr 15, 2026 | $5,600 | |||
| 5 | Maya | West | Enterprise | Apr 22, 2026 | $12,500 | |||
| 6 | Jonah | East | Pro | May 2, 2026 | $5,000 | |||
| 7 | Lena | West | Pro | May 9, 2026 | $3,900 | |||
| 8 | Theo | East | Enterprise | May 16, 2026 | $9,800 | |||
| 9 | Priya | Central | Starter | May 27, 2026 | $1,500 | |||
| 10 | Maya | West | Pro | Jun 4, 2026 | $6,200 | |||
| 11 | Jonah | East | Starter | Jun 11, 2026 | $900 | |||
| 12 | Lena | West | Enterprise | Jun 19, 2026 | $14,200 | |||
| 13 | Priya | Central | Pro | Jun 25, 2026 | $4,400 |