Excel MAXIFS function

Function              MAXIFS

Description        Excel MAXIFS function returns the largest value which meets one or more than one criteria in an array.

Syntax  MAXIFS(max_range, range1, criteria1, [range2], [criteria2], …)

max_range  Range of values from where to get maximum value.

range1  The first range to evaluate.

criteria1  The criteria to meet on range1.

range2  [optional] The second range to evaluate.

criteria2  [optional] The criteria to meet on range2.

Example:

MAXIFS function can be entered like this ways

=MAXIFS(A1:A10,D1:D10,”PASS”)

Usage Notes:

• Criteria range(s) must be the same size and shape as the max_range.