Level 2Multi-Condition MathPractice, 3 min
AVERAGEIFS: average deal in a date window
The task
What was the average deal size from H1 to H2, both days included? In H3, use
AVERAGEIFS with two conditions on the Closed column.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 | From | Apr 15, 2026 | |
| 2 | Maya | West | Pro | Apr 3, 2026 | $4,800 | To | May 31, 2026 | |
| 3 | Theo | East | Starter | Apr 7, 2026 | $1,200 | Avg deal | ||
| 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 |