MAXIFS

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

Syntax

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

Arguments

Name	Description
MaxRange	Cell-range to determine maximum value of.
CriterionRange1	The cell-range which is checked against the criterion.
Criterion1	The 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

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

Examples

	A	B	C	D
1	89	1	a	1
2	93	2	b	2
3	96	2	a	3
4	85	3	b	4
5	91	1	b	5
6	88	1	a	6

Formula	Result	Comment
MAXIFS(A1:A6, B1:B6, 1)	91	Maximum value of cells which have 1 in their B-column.
MAXIFS(A1:A6, C1:C6, "b", D6:D6, ">=2")	93	Maximum 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")	0	No cell fulfills given criterion.
MAXIFS(A1:A6, B1:D7, ">4")	#VALUE!	MaxRange and CriteriaRange have different height and/or with.