Level 2Multi-Condition MathPractice, 3 min
SUMIFS: revenue for one region and product
The task
Your VP asks: how much Pro revenue did the West close? In H3, add up Amount where the region matches H1 and the product matches H2, with
SUMIFS.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 | West | |
| 2 | Maya | West | Pro | Apr 3, 2026 | $4,800 | Product | Pro | |
| 3 | Theo | East | Starter | Apr 7, 2026 | $1,200 | Revenue | ||
| 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 |