Loading…
Loading…
MAXIFS returns the largest value among cells that meet conditions.
=MAXIFS(max_range, criteria_range1, criteria1, …)
| Argument | Required? | What it is |
|---|---|---|
| max_range | Required | The cells to take the maximum from. |
| criteria_range1 | Required | The first range to test. Add more range/criteria pairs for more conditions. |
| criteria1, … | Required | The condition for criteria_range1, such as "North" or ">100". |
Type the formula yourself and get it graded instantly, no Excel needed.