Syntax :

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

Parameters :

• The following perameter are:

max range –

• An array of numeric values (or a range of cells containing numeric values) from which the largest value should be returned if the requirements are met.

criteria range1 –

• An array of values to be evaluated against criteria1 (or a range of cells holding values).
  (Everything in this array must be the same length as the max range.)

criteria1 –

• The condition to be evaluated against the criteria range1 values.

[criteria range2, criteria2], [criteria range3, criteria3],… –

• Optional additional arrays of values to be checked and the conditions to test.