Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

AVERAGE

Description: Returns the average (arithmetic mean) of the arguments.

Syntax: AVERAGE(Number1, Number2,...)

• Number1, Number2, ... are 1 to 30 numerical arguments for which you want the average.

Remarks:

• The arguments must either be numbers or be names, arrays, or cell references that contain numbers.

• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

Example:

• AVERAGE(10, 7, 9, 27, 2) = 11

• AVERAGE(A1:A6) returns an average of the values in the cells A1 through A6.