Calculates the average of a list of arguments, including numbers, text, and logical values.
Syntax
AVERAGEA(value1, [value2], ...)Arguments
value1required
The first value, cell reference, or range to average.
value2optional
Additional values, cell references, or ranges to average.
The AVERAGEA function evaluates all arguments provided, treating text and empty strings as 0 and TRUE as 1. Unlike the standard AVERAGE function, which ignores non-numeric data, AVERAGEA includes these values in the calculation, making it useful for datasets containing mixed data types.
=AVERAGEA(10, "Text", TRUE)→3.666666667Calculates (10 + 0 + 1) / 3, where 'Text' is 0 and TRUE is 1.
Select the target cell
Click on the cell where you want the result to appear.
Enter the formula
Type =AVERAGEA( followed by your range or values, then close the parenthesis.
Execute
Press Enter to calculate the average including non-numeric entries.
AVERAGEA treats text as 0, which affects the denominator of the average calculation.