Spread 8.0 Documentation
AVERAGE
Support Options
Formula Reference > Built-In Functions > AVERAGE

Glossary Item Box

AVERAGE


Name

Average

Description

Returns the average of the specified values.

Syntax

AVERAGE(value1, value2, . . . )

Remarks

Accepts up to 30 arguments. Each argument can be a cell range, a float value, or an integer value.

See also MEDIAN and MODE.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

AVERAGE(A1,B3,D5,E9)
AVERAGE(R1C2,R3C1)
AVERAGE(A1:A9)
AVERAGE(98,72,85)=85

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.