Description
Use this function to calculate the arithmetic mean of a set of numbers. Supported in Chains. Can be used with CHILDREFS.
AVERAGE is useful for finding the central value of a range of numbers.
Syntax
AVERAGE(number_1, […, number_254])
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
number_1 |
Yes | The first number, cell reference, or range for which you want to calculate the average. | A number, a reference to a cell or cell range containing numbers, or a formula which results in any of these. |
number_n
|
No | Additional numbers, cell references, or ranges to calculate the average. | A number, a reference to a cell or cell range containing numbers, or a formula which results in any of these. |
Example
Sample data
| A | B |
|---|---|
| 10 | 20 |
| 5 | 15 |
| 30 | 25 |
| 7 | 12 |
Sample formulas
| Formula | Description | Result |
|---|---|---|
=AVERAGE(A1:A4) |
Calculates the average value in the range A1:A4. | 13 |
=AVERAGE(A1:B4) |
Calculates the average value in the range A1:B4. | 15.75 |
=AVERAGE(A2, B2) |
Calculates the average value between A2 and B2. | 10 |
=AVERAGE(10, 20, 5, 15) |
Calculates the average value among the numbers 10, 20, 5, and 15. | 12.5 |
Notes
- AVERAGE ignores empty cells, logical values, and text.
- If the range contains no numbers, AVERAGE returns a #DIV/0! error.
Tips
- You can use AVERAGE with IF to calculate the average based on a condition.
- AVERAGE can be used with other functions to calculate the average based on a condition.
- Use conditional formatting to highlight the average value in a range.
Related functions
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
LARGE
MAX
MAXA
MAXIFS
MEDIAN
MIN
MINA
MINIFS
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
RANK.AVG
RANK.EQ
SMALL
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVPA