Excel 365 + Google Sheets · MAXIFS
The maximum, with conditions
Returns the largest value among the rows that meet your conditions.
The formula
=MAXIFS(C2:C5, A2:A5, "North")What each part means
C2:C5Where the numbers areA2:A5, "North"Only these rows
Example
| A | B | C | |
|---|---|---|---|
| 1 | Region | Client | Amount |
| 2 | North | Acme | 1,200 |
| 3 | South | Bolt | 900 |
| 4 | North | Cora | 700 |
| 5 | North | Dyno | 1,450 |
| 6 | Max North |
| A | B | C | |
|---|---|---|---|
| 1 | Region | Client | Amount |
| 2 | North | Acme | 1,200 |
| 3 | South | Bolt | 900 |
| 4 | North | Cora | 700 |
| 5 | North | Dyno | 1,450 |
| 6 | Max North | 1,450 |
Step by step
- Click cell C6.
- Type the formula:
=MAXIFS(C2:C5, A2:A5, "North") - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Excel 365 and Excel 2021 or newer
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English MAXIFS
- Español MAX.SI.CONJUNTO
- Português MÁXIMOSES