Last Updated on November 1, 2023 by Jake Sheridan

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

## How to Use Google Sheets AVERAGE Function

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.

#### More basic math formulas in Google Sheets:

- Addition
- Subtract
- Multiply
- Divide
- Exponents
- MAX Function
- MIN Function
- FLATTEN Function
- FREQUENCY
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Percentages
- SUMIF
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Trimmean
- Sum Columns or Rows
- Sumif
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula