How To Get Mean In Google Sheets

If you are new to Google Sheets or just need a refresher on how to calculate the mean (average) of a data set, this blog will provide a thorough step-by-step guide. So, let’s dive right in!

What is Mean?

The Mean, also known as the average, is a measure of central tendency. It is calculated by adding up all the numbers in a data set and then dividing the result by the count of those numbers.

Calculating Mean in Google Sheets

There’s no need to carry out this task manually because Google Sheets has a built-in function called AVERAGE that does the job for you.

Step 1: Enter Your Data

First, you need to input your data into the Google Sheets. You can enter the data into any column or row of your choice.

Step 2: Use the AVERAGE Function

Once you have entered your data, click on the cell where you want the mean value to appear. Then, type in the following formula:


In this formula, ‘range‘ refers to the cell range that holds the data. For instance, if your data is in cells A1 to A10, your formula would look like this:


After typing the formula, press Enter. The mean of your data will appear in the cell where you entered the formula.


Calculating the mean in Google Sheets is a simple task if you understand the AVERAGE function. By following the steps above, you should be able to easily calculate the mean of any data set in Google Sheets. Remember, the more you practice using Google Sheets functions, the more proficient you will become in managing and interpreting your data.