The Excel AVERAGEA function returns the average of a group of supplied values. Unlike AVERAGE, AVERAGEA will also evaluate the logical values TRUE and FALSE, and numbers represented as text, whereas AVERAGE just skips these values during calculation

**Syntax**:= AVERAGEA(value1, [value2], …)

The AVERAGEA function syntax has the following arguments:

**Value1, value2, …**Value1 is required, subsequent values are optional. 1 to 255 cells, ranges of cells, or values for which you want the average.

**Example**: Let’s look at some Excel AVERAGEA function examples and explore how to use the AVERAGEA function as a worksheet function in Microsoft Excel:

**Syntax**: =AVERAGEA(A2:D2)

**Result**:

Based on the Excel spreadsheet above, the following AVERAGEA examples would return:

**Syntax**: =AVERAGEA(A3:F3)**Result**: 31

**Syntax**: =AVERAGEA(A4:E4)**Result**: 74

**Syntax**: =AVERAGEA(A5:B5)**Result**: 135

**Syntax**: =AVERAGEA(A6:E6)**Result**: 854.2

**Syntax**: =AVERAGEA(D7:E7)**Result**: 0.5

**Syntax**: =AVERAGEA(A8:E8,90)**Result**: 726.8333333

**Syntax**: =AVERAGEA(A2:D2,A2:A8)**Result**: 130.9090909

**Note**:

- AVERAGEA evaluates TRUE as 1 and FALSE as zero.
- The arguments can be numbers, names, arrays, or references that contain numbers; text representations of numbers; or logical values, such as TRUE and FALSE, in a reference.
- Arguments that contain TRUE are evaluated as 1 and arguments that contain FALSE are evaluated as 0 (zero).
- If an argument is an array or reference, only values in that array or reference are used. Empty cells and text values in the array or reference are ignored.
- The formula will return errors when the arguments are error values or text that cannot be translated into numbers.
- If we do not wish to include logical values and text representations of numbers in a reference as part of the calculation, it would be better to use the AVERAGE function.
- Differences between AVERAGE and AVERAGEA Functions: