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]:[20] contains numbers, the formula =AVERAGE([Table]![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 |
Updated 11 days ago