Get the average of a group of numbers and text

A number representing the average.

=AVERAGEA (value1, [value2], ...)

**value1**- A value or reference to a value that can be evaluated as a number.**value2**- [optional] A value or reference to a value that can be evaluated as a number.

The AVERAGEA function returns the average (arithmetic mean) of a group of supplied **values**. The key difference between AVERAGEA and AVERAGE is that AVERAGEA will also evaluate the logical values TRUE and FALSE, and numbers represented as text, whereas AVERAGE just skips these values during calculation.

For example, AVERAGE (2,4,6,8) returns 5, and AVERAGE ("2",TRUE,6,8) returns 7. AVERAGEA ("2",TRUE,6,8) returns 3.75 (17/4).

**Values** can be supplied as numbers, ranges, named ranges, or cell references that contain values. Up to 255 arguments (called "values" in this case) can be supplied.

To calculate the average, Excel adds the numeric value of each value together and divides by the total number of **values** supplied.

AVERAGEA evaluates TRUE as 1 and FALSE as zero.