AVERAGEA
Returns the average of its arguments, including numbers, text, and logical values.
StatisticalStatistics & Analysis
What it does
Calculates the average, treating text as 0 and TRUE/FALSE as 1/0.
Syntax
AVERAGEA(value1, [value2], ...)
Arguments
value1(value) — First value or range.
Examples
Average with text
Average a range where 'Absent' counts as 0.
FORMULA
=AVERAGEA(A2:A5)
RESULT
75
SAMPLE DATA
| A | |
|---|---|
| 1 | Scores |
| 2 | 100 |
| 3 | 80 |
| 4 | Absent |
| 5 | 120 |