AVERAGEIF

Returns the average of all cell values in a cell-range which meet a given criterion. To specify multiple criteria please use AVERAGEIFS.

Syntax

=AVERAGEIF(DataRange, Criterion, [AverageRange])

Arguments

Name	Type	Description
DataRange	Range	Cell-range to calculate average for.
Criterion	String	The criterion each cell has to fulfill.
AverageRange (optional)	Range	If given, these cells are used to calculate average. If ommitted DataRange is used.

Return

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

Examples

	A	B
1	100000	200
2	200000	400
3	300000	400
4	North	600
5	East	800
6	South	1000

Formula	Result	Comment
=AVERAGEIF(A1:A3, "<250000")	150000	Only cells A1 and A2 match given criterion
=AVERAGEIF(A1:A6, "=*th", B1:B6)	800	Take cells from column A which end with "th" and average corresponding values from column B