MAXIFS practice exercises
The largest value among rows that match every condition. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 4901 | East | Lena | 5 | 60 | 300 |
| 3 | 4902 | South | Raj | 9 | 12 | 108 |
| 4 | 4903 | North | Theo | 5 | 9 | 45 |
| 5 | 4904 | West | Lena | 4 | 24 | 96 |
| 6 | 4905 | East | Lena | 8 | 45 | 360 |
| 7 | 4906 | South | Omar | 7 | 30 | 210 |
| 8 | 4907 | North | Omar | 5 | 60 | 300 |
| 9 | 4908 | South | Theo | 8 | 15 | 120 |
Find the largest Revenue among South orders.
Show answer
=MAXIFS(F2:F9,B2:B9,"South")→ 210Find the largest Revenue among West orders.
Show answer
=MAXIFS(F2:F9,B2:B9,"West")→ 96Find the largest Revenue among North orders.
Show answer
=MAXIFS(F2:F9,B2:B9,"North")→ 300Find the largest Revenue among East orders.
Show answer
=MAXIFS(F2:F9,B2:B9,"East")→ 360
New to MAXIFS? Read the MAXIFS guide first: syntax, a worked example and common mistakes.