AVERAGE

Description

Returns the average of the supplied numbers. The result of AVERAGE is also known as the arithmetic mean.

Syntax

AVERAGE ( number_list )

Parameter	Description
number_list	A list of up to 30 comma-separated numbers or source fields: The list can contain numbers, logical values, or text representations of numbers. Source fields can contain only a single value. Error values or text that cannot be translated into numbers return errors. If there are no numbers in the list, 0 is returned.

Examples

This function returns 8.25:

AVERAGE(5, 6, 8, 14)

This function returns 6.6 (due to the additional number):

AVERAGE(0, 5, 6, 8, 14)

For the following example, assuming that S7 contains 34, S8 contains 227, and S9 contains 74, this function returns 111.67:

AVERAGE(S7,S8,S9)