Advanced Excel Statistical - MAXIFS Function

Description

The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria. This Function got added in Excel 2016.

MAXIFS (max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Argument	Description	Required/ Optional
max_range	The actual range of cells in which the maximum will be determined.	Required
criteria_range1	Is the set of cells to evaluate with the criteria.	Required
criteria1	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.	Required
criteria_range2, criteria2,...	Additional ranges and their associated criteria. You can enter up to 126 range/criteria pairs.	Optional

The size and shape of the max_range and criteria_rangeN arguments must be the same, otherwise these functions return the #VALUE! Error.

Excel 2016

advanced_excel_statistical_functions.htm