Returns the average of the arguments, including text (valued as 0).
AVERAGEA(value1, value2, ... value30)
value1 to value30 are up to 30 values or ranges, which may include numbers, text and logical values. Text is evaluated as 0. Logical values are evaluated as 1 (TRUE) and 0 (FALSE).
AVERAGEA(2, 6, 4)
returns 4, the average of the three numbers in the list.
where cells B1, B2, B3 contain 4, 2, and apple returns 2, the average of 4 and 2 and 0.
returns 1.5, the average of 2 and 1.