MAXIFS
Finds the highest value among rows that meet a condition.
How it’s written
MAXIFS(range_to_measure, range_to_check, condition)Example
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | North | Amara | 400 |
| 3 | South | Ben | 250 |
| 4 | North | Chloe | 150 |
| 5 | West | Dev | 700 |
=MAXIFS(C2:C5,A2:A5,"North")Result: 400
Finds the largest North sale.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
Like SUMIFS, the range you’re measuring goes first.
Practice it properly
Statistics for one group gives you real tasks, with your formulas tested on data you haven’t seen.