# 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 cells.* 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 to exclude hidden cells.* For an illustrated example refer to the Quant > Central Tendency > Mean page.* 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!