Using the Excel MAXIFS Function
SummaryThe 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 BreakdownMax Range
Required. Range of cells from which the maximum value will be found.
Criteria Range 1
Required. Cells to evaluate with a given criteria.
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.
Optional. Additional criteria to define which cell will be evaluated as the maximum.
Usage NotesMAXIFS 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.