MAXIFS
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], ...)
Parameters
- max_range: Required. The actual range of cells in which the maximum will be determined
- criteria_range1: Required. The set of cells to evaluate with the criteria
- criteria1: Required. The criteria that defines which cells will be evaluated
- criteria_range2: Optional. Additional ranges
- criteria2: Optional. Additional criteria
Example
=MAXIFS(A1:A10, B1:B10, ">5")