How to use MAXIFS Function

The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria.


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.
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.
Maxifs usage


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

Leave Comment

Your email address will not be published. Required fields are marked *

OCL Learning | Training, Consulting, Certification