**Home ► Excel Functions ► Excel AVERAGE Function**

**What is the use of Excel AVERAGE Function?**

Use **Excel AVERAGE Function** to calculate the average of given numbers. In simple words, it will first sum the numbers & then divide that sum by the count of numbers. For example, for 10, 20, 30 it will return 30 as an average.

**Syntax for Excel AVERAGE Function**

**AVERAGE(number1,number2,…)**

**number1 **A numeric value for which you want to get the average. **[Required]**

**number2 **A numeric value for which you want to get the average.** [Optional]**

**More Information on Excel AVERAGE Function**

- You can specify an argument as a number, named range &cell reference.
- It will ignore empty cells, cells with text, cells with logical values.
- If a cell has 0 in it, it will count that cell to calculate average.
- If you enter a logical value or a text which represents a number as an argument directly into the function, that will be counted.
- It will return an error if the argument is an error value or text values which cannot be converted into a number.

**Examples to understand Excel AVERAGE Function**

In above example, I have entered arguments directly into the function. As I have already mentioned you can specify maximum 255 arguments.

In above example, I have referred to a range which has numbers in it. You can refer to the unlimited cell by using a continues range. And, if you want to refer to a dynamic range you can use a table for that.

If any of the cells which is referred has an error value if will return an error in the result.

In above example, I have referred to a range in which cell has formatted as text. In this case, you can convert those text numbers into the actual numbers.

A cell will also ignore for averaging if that cell is preceded by an apostrophe.

**Download Sample File**

**Conclusion**

Use **Excel AVERAGE Function** to calculate the average of numeric values. Learn more about AVERAGE from **here**.