AVERAGE function

The AVERAGE function in Excel calculates the arithmetic mean of a range of numbers. It is a simple way to find the average value of a set of data points.


AVERAGE(number1, [number2], …)


number1The first number or range you want to include in the average.
[number2](Optional) Additional numbers or ranges you want to include in the average. You can add up to 255 arguments.

How to use

To use the AVERAGE function in Excel, follow these steps:

Here are some examples of how to use the AVERAGE function:

This formula calculates the average of the numbers in cells A1 to A5.

Here, we directly list the numbers we want to average.

Keep in mind that the AVERAGE function only considers numbers and ignores any empty cells or text values. If you have non-numeric data in your range, it won’t affect the result.

Additional Information:

If you need more details or have specific questions about using Excel functions, you can refer to the official Excel documentation.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.