Note:AVERAGE
Description
AVERAGE 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 numbers separated by the corresponding list separator. As many as 30 numbers can be included in the list, and the list can contain numbers or a reference to a range that contains numbers. Text, logical expressions, or empty cells in a referenced range are ignored. All numeric values (including 0) are used. |
Examples
This function returns 8.25:
AVERAGE(5, 6, 8, 14)
This function returns the average of the values in the range C15 through C17:
AVERAGE(C15:C17)
Note:
If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.
Also, see