In Google Sheets, four quick methods exist to calculate the average of numeric values. And in the tutorial, we will learn to use and understand these methods in detail.
AVERAGE Function
In Google Sheets, you can use a specific function to get the average of the values. In the below example, you have values in the range A1:A10.
=AVERAGE(A1:A10)
In the AVERAGE function, you need to specify the range to calculate the average values. And if you have text value in the range along with the number, this function will not consider it while calculating the average for you.
Create an Average Formula with SUM and COUNT
You can also create a custom formula by combining SUM and COUNT to get the average.
=SUM(A1:A10)/COUNT(A1:A10)
With this formula, you can sum the values first and then get the count of the numeric values. In the end, divide the sum by the count of the values, giving you the average. And just like the first method, this will also ignore the text values from the range to get the average.
AVERAGEA Function
This function is a little different from the first one. In the below example, when you use AVERAGEA, it gives you the result 122.8.
Let me help you to understand it.
You have 10 values and out of which 9 values are numbers, and one is a text. Now, it sums 9 values and divides them with the 10 (total count of values) and gives you the result. That means this result could be a little misleading.
Getting Average from the Bottom Bar (Explore)
At the bottom of the Google Sheet’s window (before the Explore Button) is how to find some quick calculations. The moment you select the range, you can see it there.
And if you want to change the calculation, you need to click on it to get the drop-down.