AVERAGEA
Category: Statistical Function.
Description: Returns the average (arithmetic mean) of a list of numbers.
Syntax: AVERAGEA( number1, [number2], ... )
The difference compared to the AVERAGE function is that within arrays or reference arguments, logical values are counted as 1 or 0, and text is counted as zero.