In this tutorial, you will learn how to use the AVERAGE function in Google Sheets.

## How to Use Google Sheets AVERAGE Function

Quick Navigation

The AVERAGE function in Google Sheets is useful if you need a way to quickly find the mean of a range of values.

The AVERAGE function can be used to average numerical data, such as a list of test scores or a dataset of stock prices.

The function is also useful for finding the average of dates, such as a list of birthdates or even percentages. The AVERAGE function is essential in fields such as statistics, where various metrics often rely on knowing the mean of a range of data.

In this guide, we will show you how to use the AVERAGE function in Google Sheets.

## How to Find the Average of a Range of Values in Google Sheets

Here’s how to find the average value of a range in Google Sheets.

### Step 1

First, select an empty cell to place the AVERAGE function.

In this example, we want to find the average height from a list of randomly selected participants. We want to output the average height in cell **D1**.

### Step 2

Type the string “=AVERAGE(“ to start the AVERAGE function.

### Step 3

Next, we’ll need to specify the values to use for the AVERAGE function. You can provide a list separated by commas or an entire cell range.

In this example, we want to find the mean of the cell range **A2:A16**.

The AVERAGE function simply finds the sum of the range of values and divides the total by the number of values in the range.

### Step 4

Do note that the AVERAGE function automatically skips blank cells present in the range.

However, the AVERAGE function considers 0 as a valid value. Cells with a value of 0 are counted when dividing the total sum by the number of numerical values.

## Summary

This guide should be everything you need to use the AVERAGE function in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.