Use Excel AVERAGE Function to calculate the average of given numbers. In simple words, it will first sum the numbers and then divide that sum by the count of numbers.

For example, for 10, 20, 30 it will return 30 as an average.

Syntax

AVERAGE(number1,number2,…)

number1 A numeric value for which you want to get the average.

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

More Information on Excel AVERAGE Function

You can specify an argument as a number, named range or a cell reference.

It will ignore an empty cell, a cell with a text, and a cell with a logical value.

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 an argument is an error value or a text value which cannot be converted into a number.

Examples

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

In the below example, we have referred to a range which has numbers. 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 it will return an error in the result.

In the below example, we have referred to a range in which cells are formatted as a text value. In this case, you can convert those text numbers into the actual numbers to calculate average.

A cell will also be ignored if that cell is preceded by an apostrophe.

Sample File

What’s Next?

To learn more about Excel AVERAGE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.