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.
Syntax
AVERAGE(number1, [number2], …)
Arguments
| number1 | The 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:
|
1 |
=AVERAGE(number1, [number2], ...) |
Here are some examples of how to use the AVERAGE function:
|
1 |
=AVERAGE(A1:A5) |
This formula calculates the average of the numbers in cells A1 to A5.
|
1 |
=AVERAGE(B1, B2, B3, B4, B5) |
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.