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

Column 1

Column 2

Column 3

10

15

32

7

9

27

2

Formula

Description

Result

=AVERAGE([Table]![1][1]:[1][5])

Average of the numbers in column 1

11

=AVERAGE([Table]![1][1]:[1][5], 5)

Average of the numbers in column 1 and the number 5.

10

=AVERAGE([Table]![1][1]:[3][1])

Average of the numbers in row 1

19