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.
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.
Type the string “=AVERAGE(“ to start the AVERAGE function.
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.
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.
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:
- MAX Function
- MIN Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- 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
- Sum Columns or Rows
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula