MAXIFS function
Summary
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.
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.
Example
=MAXIFS(A2:A7,B2:B7,1)
=MAXIFS(A2:A5,B3:B6,"a")
=MAXIFS(A2:A7,B2:B7,"b",D2:D7,">100")
=MAXIFS(A2:A7,B2:B7,"b",D2:D7,A8)
=MAXIFS(A2:A5,B2:c6,"a")
=MAXIFS(A2:A6,B2:B6,"a",D2:D6,">200")
=MAXIFS(A2:A5,B3:B6,"a")
=MAXIFS(A2:A7,B2:B7,"b",D2:D7,">100")
=MAXIFS(A2:A7,B2:B7,"b",D2:D7,A8)
=MAXIFS(A2:A5,B2:c6,"a")
=MAXIFS(A2:A6,B2:B6,"a",D2:D6,">200")