# 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,...)`

`AVERAGEA(array)`

`AVERAGEA(array1, array2,...)`

## Arguments

Each argument can be a double-precision floating-point value, an integer value, or an array (cell range). Up to 255 arguments may be included. 
You can use a single array (cell range) instead of a list of values. 
You can use multiple arrays (cell ranges) as well.

## Remarks

This is a measure of the variability in a data set.

This function differs from [AVERAGE](/spreadjs/docs/v17/formulareference/FormulaFunctions/statistical-functions/AVERAGE) because it allows text or logical values as well as numeric values.

## Data Types

Accepts numeric, logical, or text data for all arguments. Returns numeric data.

## 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