Average

The AVERAGE function returns the average (arithmetic mean) of the numbers provided.

Returns the average (arithmetic mean) of the arguments. For example, if the range [Table]![1][1]:[1][20] contains numbers, the formula =AVERAGE([Table]![1][1]:[1][20]) returns the average of those numbers.

Syntax

AVERAGE(value1, [value2], ...)

The AVERAGE function syntax has the following arguments:

• value1 Required. The first number, cell reference, or range for which you want the average.
• value2, ... Optional. Additional numbers, cell references or ranges for which you want the average, up to a maximum of 255.

Example