﻿ AVERAGE | Spread.NET 15 Formula Reference
Formula Functions / Functions A to C / AVERAGE
In This Topic
AVERAGE
In This Topic

This function calculates the average of the specified numeric values.

#### Syntax

AVERAGE(value1,value2,...)

AVERAGE(array)

AVERAGE(array1,array2,...)

#### Arguments

Each argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. 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 AVERAGEA, which accepts text or logical values as well as numeric values.

#### Data Types

Accepts numeric data for all arguments. Returns numeric data.

#### Examples

AVERAGE(A1,B3,D5,E9,L8,L9)

AVERAGE(R1C1,R3C2)

AVERAGE(A1:A9)

AVERAGE(A1:A9,B1:B9,D5:D8)

AVERAGE(98,72,85) gives the result 85

#### Version Available

This function is available in product version 1.0 or later.