Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.
Syntax
AVERAGE(number1, [number2], …)
The AVERAGE function syntax has the following arguments:
- Number1: Required. The first number, cell reference, range or function for which you want the average.
- Number2, … : Optional. Additional numbers, cell references, ranges or function for which you want the average, up to a maximum of 255.
Specifics
- Arguments can either be numbers, ranges, cell references or functions that contain numbers.
- Functions must return a number value, and the results counts as a sigle argument only when perfoming the average calculation. For example if the function is the SUM(A1:A10), this will count a one element, not 10 when calculating the average.
- Any text (other than digits) that you type directly into the list of arguments are not alowed.
- If a range or cell reference argument contains empty cells, those values are ignored; however, cells with the value zero are included.
- Arguments that are error values or text that cannot be translated into numbers cause errors.
Examples
| Data (Cell A1) | ||
|---|---|---|
| 10 | 15 | 32 |
| 7 | ||
| 9 | ||
| 27 | ||
| 2 | ||
| Formula | Description | Result |
| =AVERAGE(A2:A6) | Average of the numbers in cells A2 through A6. | 11 |
| =AVERAGE(A2:A6, 5) | Average of the numbers in cells A2 through A6 and the number 5. | 10 |
| =AVERAGE(A2:C2) | Average of the numbers in cells A2 through C2. | 19 |
| =AVERAGE(SUM(1,2), 3) | Average of 1+2 and 3, which is 6 / 2, as the function is counted as one element. | 3 |
KC Integrations 