AVERAGE function in Google Sheets - Step-by-Step Guide

Introduction

The AVERAGE function helps you find the middle value of a group of numbers. It adds all the numbers together and then divides by how many numbers there are. This is useful when you want to know the typical value in a list, like average test scores or daily sales.

When you want to find the average score of students in a class.

When you need to calculate the average daily temperature for a week.

When you want to know the average sales amount from a list of transactions.

When you want to find the average time spent on a task from several records.

When you want to summarize the average rating from customer feedback scores.

Steps

Step 1: Click

- the cell where you want the average result to appear

The cell is selected and ready for input

Step 2: Type

- the selected cell

The formula input starts in the cell

💡 Start by typing =AVERAGE(

Step 3: Select

- the range of cells containing the numbers you want to average

The cell range is highlighted and added to the formula

Step 4: Type

- the formula input

The formula is completed

💡 Close the formula with a closing parenthesis )

Step 5: Press

- Enter key

The cell shows the average of the selected numbers

Before vs After

Before

Cells A1 to A5 contain numbers: 10, 20, 30, 40, 50. Cell B1 is empty.

After

Cell B1 shows 30, which is the average of the numbers in A1 to A5.

Settings Reference

Function name

📍 Formula bar when typing a formula

Specifies the function to calculate the average of numbers

Default: AVERAGE

Cell range

📍 Inside the parentheses of the formula

Defines which numbers to include in the average calculation

Default: None

Common Mistakes

Typing =AVERAGE without selecting any cells or numbers

The formula has no numbers to calculate, so it returns an error or zero.

Always include a range or list of numbers inside the parentheses, like =AVERAGE(A1:A5).

Including text or empty cells in the range

Text and empty cells are ignored, which might give unexpected results if you expect them to count as zero.

Make sure the range only includes cells with numbers or handle text separately.

Summary

The AVERAGE function calculates the middle value of a group of numbers by adding them and dividing by the count.

You must select the cells with numbers inside the parentheses for the function to work.

Text and empty cells in the range are ignored and do not affect the average.