averagea
Arithmetic mean treating text as 0 and TRUE as 1.
Syntax
Section titled “Syntax”v = averagea(value1, value2, ...)Description
Section titled “Description”Like average but counts text values as 0 and logical TRUE as 1 in the average. Useful when blanks should not influence the mean but mistyped text entries should pull the average down.
Example
Section titled “Example”averagea(2, 4, 'blue') % 2 (text counted as 0: (2+4+0)/3)See also
Section titled “See also”average— Arithmetic mean of numeric arguments (Excel-compatible).