AVERAGEIFS

Definition:

This function calculates the average of all cells that meet multiple specified criteria.

Syntax:

AVERAGEIFS(value1,condition1,value2,...,condition2...)

AVERAGEIFS(array,condition)

AVERAGEIFS(array1,array2,...,condition)

Notes

Arguments

Each argument can be a double-precision floating-point value, an integer value, or an array (cell range). Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well. You can have up to 127 aguments for the conditions.

Remarks

This is a measure of the variability in a data set.

Data Types

Accepts numeric data. The condition accepts text, numeric, or expression data. Returns numeric data.

Step 1.  To begin to use AVERAGEIFS formula, start with the Excellentable you would like to edit..

Step 2. Then type the AVERAGEIFS formula into the cell you have chosen to display the outcome: 

Step 3. Excellentable will generate the outcome when hitting enter. 

	A	B	C
1		Value
2		-1
3		2
4		3
5		4
6		5
7		6
8		7
9
10
11
12		Result	Formula
13		4	AVERAGEIFS(B2:B8,B2:B8,">0",B2:B8,"<7")