Excel AVERAGE Function
The Excel AVERAGE function returns the average of values provided. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.
- number1 - A number or cell reference that refers to numeric values.
- number2 - [optional] A number or cell reference that refers to numeric values.
The AVERAGE function calculates the average of numbers provided as arguments. To calculate the average, Excel adds the numbers together and divides by the total number of values supplied. AVERAGE can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.
The example below shows how values can be hardcoded directly into the AVERAGE function:
=AVERAGE (2,3,4) // returns 3
AVERAGE can also be used to calculate the average of a range of cells:
=AVERAGE(A1:A3) // returns 3
The AVERAGE function can handle up to 255 arguments, which can be a mixture of references and constants:
=AVERAGE(A1,A2,4) // returns 3
See more examples of the AVERAGE function below.
The AVERAGE function will ignore logical values and numbers entered as text. If you need to include these values in the average, see the AVERAGEA function.
If the values provided to AVERAGE function contain errors, AVERAGE returns an error. You can use the AGGREGATE function to ignore errors.