MAXIFS
Returns the maximum value among cells specified by a given set of conditions or criteria.
StatisticalModern Excel FunctionsStatistics & Analysis
What it does
Returns the largest number in a range that meets multiple criteria.
Syntax
MAXIFS(max_range, criteria_range1, criteria1, ...)
Arguments
max_range(range) — Range to check for max.criteria_range1(range) — Range to evaluate.criteria1(criteria) — Condition.
Examples
Max If
Max score for 'A'.
FORMULA
=MAXIFS(B2:B5, A2:A5, "A")
RESULT
95
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Group | Score |
| 2 | A | 80 |
| 3 | B | 70 |
| 4 | A | 95 |
| 5 | B | 88 |