Exercises / Conditional counting and sums · 8 of 11
Biggest sale in a region
MAXIFS(max_range, range1, criteria1, …) returns the largest value among the rows that meet the conditions. MINIFS does the same for the smallest.
Your taskIn H2, use MAXIFS to return the largest amount in E2:E13 for the region in H1.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Date | Region | Rep | Product | Amount | Region | South | |
| 2 | 1 Jan 2026 | North | Ana | Laptop | $1,450.00 | Biggest sale | ||
| 3 | 2 Jan 2026 | South | Ben | Monitor | $320.00 | |||
| 4 | 2 Jan 2026 | North | Ana | Monitor | $290.00 | |||
| 5 | 4 Jan 2026 | East | Cara | Laptop | $1,380.00 | |||
| 6 | 5 Jan 2026 | North | Dino | Monitor | $310.00 | |||
| 7 | 6 Jan 2026 | South | Ben | Laptop | $1,520.00 | |||
| 8 | 7 Jan 2026 | North | Ana | Dock | $180.00 | |||
| 9 | 8 Jan 2026 | East | Cara | Monitor | $305.00 | |||
| 10 | 9 Jan 2026 | North | Dino | Laptop | $1,490.00 | |||
| 11 | 11 Jan 2026 | South | Ben | Monitor | $335.00 | |||
| 12 | 12 Jan 2026 | North | Ana | Monitor | $299.00 | |||
| 13 | 13 Jan 2026 | East | Cara | Dock | $175.00 |