The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria.
Syntax
MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
| max_range (required) | The actual range of cells in which the maximum will be determined. |
| criteria_range1 (required) | Is the set of cells to evaluate with the criteria. |
| criteria1 (required) | Is the criteria in the form of a number, expression, or text that defines which cells will be evaluated as maximum. The same set of criteria works for the MINIFS, SUMIFS, and AVERAGEIFS functions. |
| criteria_range2, criteria2, …(optional) | Additional ranges and their associated criteria. You can enter up to 126 range/criteria pairs. |
Remarks
The size and shape of the max_range and criteria_rangeN arguments must be the same, otherwise these functions return the #VALUE! error.
Watch MAXIFS in action