Excel functions / Maths & statistics
MAXIFS & MINIFS
Return the largest or smallest value that meets one or more conditions.
Syntax
=MAXIFS(max_range, criteria_range1, criteria1, ...)Arguments
max_range | The values to pick the largest (or smallest) from. |
|---|---|
criteria_range, criteria | Pairs of a range and its condition. |
How it works
MAXIFS answers questions like "what was the biggest sale in the West?" It works like SUMIFS: the values come first, then pairs of ranges and conditions. MINIFS works the same way for the smallest.
Example
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Rep | Sales | ||
| 2 | East | Ana | 500 | 700 | |
| 3 | West | Ben | 300 | ||
| 4 | East | Cal | 250 | ||
| 5 | West | Dee | 700 | ||
| 6 |
Result: 700. The West sales are 300 and 700.
Tips
- Available in Excel 2019 and later.
Practise MAXIFS & MINIFS
Try it yourself in a real spreadsheet, with instant feedback on every answer.