Excel Function AVERAGEA

AVERAGEA(value1 [,value2] [..])

Returns the arithmetic mean of non blank cells in a list, table or cell range (including logical values and text).

value1	The first value.
value2	(Optional) The second value.

Remarks

* This function is identical to the AVERAGE function except that logical values and text are included in the denominator.
* This function includes hidden rows.
* Arguments that are numbers are included.
* Arguments that are zero are included.
* Arguments that are dates are included.
* Arguments that evaluate to True are included and 1 is used.
* Arguments that evaluate to False are included and 0 is used.
* Arguments that are text are included and 0 is used.
* If any cell references are empty, then these are excluded.
* If any cell references contain an error, then that error is returned. (Row 15)
* You can have a maximum of 255 arguments.
* You can use the AVERAGE function to return the arithmetic mean of non blank cells in a list, table or cell range.
* You can use the AVERAGEIFS function to satisfy multiple conditions.
* You can use the AVERAGEAVISIBLE - User Defined Function if you want to exclude hidden rows.
* For an illustrated example refer to the page under Quant > Central Tendency > Mean.
* This is similar to the COUNTA function.
* This is similar to the MAXA function.
* This is similar to the MINA function.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=AVERAGEA(2,4) = 3	5
2	=AVERAGEA(5,10,15) = 10	10
3	=AVERAGEA(5,10,15,0) = 8	15
4	=AVERAGEA(2,3,4,5,6) = 4
5	=AVERAGEA({2,3,4,5,6}) = 4	0
6	=AVERAGEA(B1:B3) = 10	text
7	=AVERAGEA(B1,B2,B3) = 10	FALSE
8	=AVERAGEA(B1,B2,B3,B4) = 10	=10/0 = #DIV/0!
9	=AVERAGEA(B1,B2,B3,B6) = 8
10	=AVERAGEA(B1,B2,B3,B5) = 8
11	=AVERAGEA(1,2,3) = 2
12	=AVERAGEA(1,2,3,TRUE) = 1.8
13	=AVERAGEA(1,2,3,FALSE) = 1.5
14	=AVERAGEA(named_range) = 10
15	=AVERAGEA(B5,B6,B8) = #DIV/0!
16	=AVERAGEA(2,"some text") = #VALUE!