AVERAGE

See also A-Z Spreadsheet Function List

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

Syntax AVERAGE(number_list)

number_list is a list of numbers separated by commas. 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.

See Also MIN and MAX functions

Examples AVERAGE(5, 6, 8, 14) returns 8.25

         AVERAGE(C15:C17) returns 134; C15:C17 contains 24,144, and 234