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.
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.
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.