Skip to main content

MAXIFS

Returns the maximum value of all cells which meet multiple criteria.

Syntax

=MAXIFS(MaxRange, CriterionRange1, Criterion1, [CriterionRange2, Criterion2], ...)

Arguments

NameDescription
MaxRangeCell-range to determine maximum value of.
CriterionRange1The cell-range which is checked against the criterion.
Criterion1The criterion each cell of CriterionRange1 has to fulfill.
CriterionRange2,...Optional. Additional cell-range which is checked against next criterion.
Criterion2,...Optional. Additional criterion each cell of CriterionRange2 has to fulfill.

Return Value

The maximum of all cell values which meet all specified criteria.

Example

ABCD
1891a1
2932b2
3962a3
4853b4
5911b5
6881a6
FunctionResultComment
MAXIFS(A1:A6, B1:B6, 1)91Maximum value of cells which have 1 in their B-column.
MAXIFS(A1:A6, C1:C6, "b", D6:D6, ">=2")93Maximum value of all cells which have "b" in their C-column and its D-column value is greater or equal 2.
MAXIFS(A1:A6, B1:B6, ">4")0No cell fulfills given criterion.
MAXIFS(A1:A6, B1:D7, ">4")#VALUE!MaxRange and CriteriaRange have different height and/or with.