AVERAGE function in Excel - Step-by-Step Guide

Introduction

The AVERAGE function calculates the mean value of a group of numbers. It helps you find the typical value in a list, like the average score or average price, without doing the math yourself.

When you want to find the average test score of a class from a list of scores.

When you need to calculate the average sales amount from daily sales data.

When you want to know the average temperature over a week from recorded daily temperatures.

When you want to find the average price of items in a shopping list.

When you want to quickly summarize the average time spent on tasks from a time log.

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 selected cells are highlighted and their addresses appear in the formula

Step 4: Type

- the formula bar or cell

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

Number format

📍 Home tab > Number group

Controls how the average result is displayed, such as decimal places or currency symbol

Default: General

Common Mistakes

Typing the formula without parentheses, like =AVERAGE

Excel needs parentheses to know which cells to average.

Always include parentheses with the cell range inside, like =AVERAGE(A1:A5)

Including text cells in the range

Text cells are ignored, but if all cells are text, the result will be an error.

Select only cells with numbers or ensure at least one number is in the range.

Summary

The AVERAGE function finds the mean value of numbers in a selected range.

Use it to quickly calculate typical values like average scores or prices.

Remember to include parentheses and select only number cells for accurate results.