AVERAGEA
Returns the average of its arguments, including numbers, text, and logical values
Syntax
AVERAGEA(value1, [value2], ...)
Parameters
- value1: Required. The first value, cell reference, or range
- value2: Optional. Additional values, up to 255
Example
=AVERAGEA(A1:A10)