Functions
AVERAGEA
Average including booleans and text
Try it
When to use it
When should I use AVERAGEA instead of AVERAGE?
Use AVERAGEA when your dataset includes boolean values or text that should be counted as 0 (FALSE/text) or 1 (TRUE); AVERAGE silently ignores non-numeric values, while AVERAGEA includes them.
Used in
science · operations · education
Syntax
AVERAGEA(value1,...)Examples
=AVERAGEA(1,2,3,4,5,6,7,8,9,10,4,26) // => 7.083333333333333
=AVERAGEA(1,2,3,4,5,7,8,9,10,11,12) // => 6.545454545454546