# AVERAGEA

## Content

This function calculates the average of the specified values, including text or logical values as well as numeric values.

## Syntax

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

## Arguments

This function has these arguments:

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

## Remarks

This is a measure of the variability in a data set.
This function differs from [AVERAGE](/document-solutions/java-excel-api/docs/online/formula-reference/statistical-functions/average) because it allows text or logical values as well as numeric values.

## Examples

`AVERAGEA(A1,B3,D5,E9,L8,L9)`
`AVERAGEA(R1C1,R3C2)`
`AVERAGEA(A1:A9)`
`AVERAGEA(A1:A9,B1:B9,D5:D8)`
`AVERAGEA(98,72,85)` gives the result 85