AVERAGEIFS

Returns the average of all cell values which meet multiple criteria.

Syntax

=AVERAGEIFS(AverageRange, CriterionRange1, Criterion1, [CriterionRange2,...], [Criterion2,...])

Arguments

Name	Type	Description
AverageRange	Range	Cell-range to calculate average for.
CriterionRange1	Range	The cell-range which is checked against the criterion.
Criterion1	String	The criterion each cell of CriterionRange1 has to fulfill.
CriterionRange2,... (optional)	Range	Additional cell-range which is checked against next criterion.
Criterion2,... (optional)	String	Additional criterion each cell of CriterionRange2 has to fulfill.

Return

Type	Description
Number	The average over all cell values which meet all specified criteria.

Examples

	A	B	C	D
1	230000	Freiburg	3	No
2	197000	Cologne	2	Yes
3	345678	Cologne	4	Yes
4	Freiburg	321900	2	Yes
5	Cologne	203000	3	No

Formula	Result	Comment
=AVERAGEIFS(A1:A5, B1:B5, "Cologne", C1:C5, ">2")	200000	Average price of houses in Cologne that have at least 3 rooms.
=AVERAGEIFS(A1:A5, C1:C5, ">=4")	345678	Average price of houses with 4 or more rooms.
=AVERAGEIFS(A1:A5, C1:C5, ">4")	#DIV/0!	No cell fulfills given criterion.