How to Use AVERAGE Function in Google Sheets (4 Examples)

The AVERAGE function is one of the basic and useful functions in Google Sheets. It helps the users to get an arithmetic mean of a set of numerical values. You can calculate the average of values or a range of cells in Google Sheets. In this article, we will explain the anatomy of this function and a few suitable examples of how to use the AVERAGE function in Google Sheets.

How to use AVERAGE function in google sheets

A Sample of Practice Spreadsheet

You can download the practice spreadsheet from the download button below.

What Is AVERAGE Function in Google Sheets?

The AVERAGE function returns the arithmetic mean of a set of numerical values.


The Syntax of the AVERAGE function is shown below.

AVERAGE(value1, [value2, โ€ฆ])

Syntax of AVERAGE function


value1 Required The first value or range to consider when calculating the average value.
value2 Optional Additional values or ranges to consider when calculating the average value.


The formula AVERAGE(1,2,3) will return 2 because the arithmetic average of these three values is 2.

4 Suitable Examples of Using AVERAGE Function in Google Sheets

There are various ways you can find averages from a dataset using the AVERAGE function.

Suppose, you have a dataset that contains the monthly salary of some employees of a company in the first three months of a particular year.

Dataset of the AVERAGE function

You can find the average salary for each person using the AVERAGE function.

Here, you can find averages in multiple ways in a dataset. You can use the cell values, and range of cells or combine both of them.

1. Using Cell Values

You can easily find the average of some numerical values using the AVERAGE function. This is a very simple thing to do. Now we will find the average using some direct values from the dataset. Follow the steps below to learn how to do that.

๐Ÿ“Œ Steps:

  • At the very beginning, select cell F5 in the dataset.

Selecting a cell

  • Subsequently, to find the salary average of Adam, insert the following formula.
  • Following, hit the Enter key.

Inserting formula

  • After that, input the respective values of other employees similarly.
  • Finally, you will get the averages for all the employees.

Apply formula in other cells.

Read More: How to Average Cells from Different Sheets in Google Sheets

2. Using Cell Reference

Now, we have put the direct values in some cells. Besides, we can find the averages using cell references. Please read along furthermore to learn how to do that by yourself.

๐Ÿ“Œ Steps:

  • First, select cell F5 and insert the following formula in the formula bar.
  • Subsequently, press the Enter key.

Inserting formula

  • Next, drag down the fill handle tool to copy the formula similar to other relevant cells.

Drag down fill handle tool

  • Finally, you will see the average of the next relevant cells.

Using the AVERAGE function in Google Sheets

Read More: Calculate Average of Last N Rows in Google Sheets (3 Ways)

3. Combining Values and Cell References

Moreover, you can also find the averages combining direct values and cell references. At this time, we will use the AVERAGE function and put both the values and cell references in it. Follow the next steps and you can also do that.

๐Ÿ“Œ Steps:

  • First, enter the following formula in cell F5.

Inserting formula

  • Then, you will get the average in that cell.
  • Similarly, you can select specific cells and add values to find the average for other cells similarly.

Using the AVERAGE function in Google Sheets

Read More: How to Add Average Line in Google Sheets (With Detailed Steps)

4. Using Disoriented Cell Ranges

Furthermore, if you need to find the average of some disoriented cell ranges in a dataset, that can also be done using the AVERAGE function.

For example, here is a dataset where the salary of Adam and Kevin are given for 3 consecutive months. Following, their January salaries are mentioned respectively in cells C5 and C6, February salaries in cells D7 and D8, and finally their salaries for March are subsequently in cells E9 and E10.


You need to find the average of their salary. Read the below steps to learn that.

๐Ÿ“Œ Steps:

  • First, select the cell E12 and enter the below-mentioned formula.
  • Following, hit the Enter key.
  • Next, the average will be in the selected cell.

Using the AVERAGE function in Google Sheets

Things to Remember

  • The AVERAGE function ignores texts and boolean values(TRUE/FALSE).
  • The AVERAGE function ignores blank cells but includes a cell containing zero value.


So, in this article, we have tried to show you how to use the AVERAGE function in Google Sheets. Hopefully, the methods above will be enough for you to understand the applications of the function. Besides, please use the comment section below for further queries or suggestions. You may also visit our OfficeWheel blog to explore more about Google Sheets.

Related Articles



Hello everyone! This is Maruf Hasan. I am working as a Content Developer at Officewheel. Here we make content on google sheets. We share simple methods to make your google sheets journey enjoyable. I love solving problems, researching, and writing.

We will be happy to hear your thoughts

Leave a reply