MAXIFS

Using the Excel MAXIFS Function

Summary

The Excel MAXIFS function returns the largest numeric value in a range of values that meets a specific condition or criteria. MAXIFS can be used with criteria that includes dates, numbers, text, and other conditions. The function supports logical operators (<, >, <>, =) and wildcard characters (? and *).

Use the MINIFS function to find the smallest value in a range of values based on specific criteria.


Syntax

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

Syntax Breakdown

Max Range
Required. Range of cells from which the maximum value will be found.

Criteria Range 1
Required. Cells to evaluate with a given criteria.

Criteria 1
Required. Criteria can be in the form of a number, date, expression, or text and defines which cells will be evaluated as the maximum. The criteria also works for MINIFS, SUMIFS, and AVERAGEIFS.

Criteria Range 2
Optional. Additional cells to evaluate with a given criteria. The function can accept up to 126 range/criteria pairs.

Criteria 2
Optional. Additional criteria to define which cell will be evaluated as the maximum.


Usage Notes

MAXIFS returns the largest value that meets specific conditions from a range of values.

Criteria ranges must be the same size and shape as max_range, or the function returns the #VALUE! error.