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.