AVERAGEA
Description
Returns the average value from a list of values. Similar to AVERAGE(), but in AVERAGEA() you can include text and logical values. A text value or logical FALSE value is treated as a 0; a logical TRUE is counted as a 1.
Syntax
AVERAGEA(
value1
, [
value2
], ...)
- value1: The value, or list of values.
- value2: The value, or list of values.