AVERAGEA function
Summary
Returns the average of its arguments, including numbers, text, and logical values
Syntax
AVERAGEA(value1, [value2], ...)
The AVERAGEA function syntax has the following arguments:
• Value1, value2, ... Value1 is required, subsequent values are optional. 1 to 255 cells, ranges of cells, or values for which you want the average.
• Value1, value2, ... Value1 is required, subsequent values are optional. 1 to 255 cells, ranges of cells, or values for which you want the average.
Example
=AVERAGEA(A2:A6)
=AVERAGEA(A2:A5,A7)
=AVERAGEA(A2:A5,A7)