MAXIFS and MINIFS

New Excel function in Excel 2016

The MAXIFS and MINIFS functions work in the same way as the existing SUMIFS function. The maximum or minimum value of a range is returned based on one or more criteria.

Syntax

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

The max_range is the range from which the maximum value is returned. The criteria_range is the range that is checked to see if it matches to the criteria.

Where ever there is a match the values from the max_range are filtered and then the maximum value is determined.

Comments

The ranges used by the max_range and criteria_range must be the same size otherwise a #VALUE! will be returned.

Limitations

The functions can have up to 126 criteria.

Tip

It is best to use cell references for the criteria rather than hard coding them.

Examples