﻿ AVERAGEA | Spread Formula Reference
Spread Formula Reference
Formula Functions / Functions A to C / AVERAGEA
In This Topic
AVERAGEA
In This Topic

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

#### Version Available

This function is available in product version 2.0 or later.