The AVERAGE function in Excel calculates the mean of a group of numbers. Instead of manually adding numbers and dividing by the count, Excel performs the calculation automatically. This makes AVERAGE one of the most commonly used Excel functions for analyzing data such as sales totals, grades, expenses, and performance metrics.
In this guide, you’ll learn:
• What the AVERAGE function does
• How to calculate an average in Excel
• How to average non-adjacent cells
• How Excel handles blanks, zeros, and text
• Common mistakes to avoid
• Real-world uses of the AVERAGE function
By the end of this tutorial, you’ll be able to confidently calculate averages in Excel using multiple methods.
What the AVERAGE Function Does in Excel
The AVERAGE function calculates the arithmetic mean of a group of numbers.
It works by:
- Adding all numbers
- Dividing by how many numbers exist
For example:
If you average:
10, 20, 30
Excel calculates:
(10 + 20 + 30) ÷ 3 = 20
Instead of doing this manually, Excel performs the calculation instantly using the AVERAGE function.
AVERAGE Function Syntax
H2: AVERAGE Function Syntax
Every Excel function follows a structure called syntax.
The syntax for the AVERAGE function is:
=AVERAGE(number1, [number2], ...)
Syntax Breakdown
number1 — The first number or range
number2 — Optional additional numbers or ranges
You can include:
• Individual numbers
• Cell references
• Ranges
• Multiple ranges
Example Dataset Used in This Tutorial
You can download the sample data we’ll be using in this tutorial by clicking on this link—> AVERAGE Function Data
How to Use the AVERAGE Function in Excel
This example shows how to calculate the average monthly sales amount.
Click cell B7.
This is where the average will appear.
Type:
=AVERAGE(B2:B6)
Press Enter.
Excel will calculate the average sales amount.
How the AVERAGE Function Works
The AVERAGE function performs two calculations automatically.
First, Excel adds all numbers:
1250 + 980 + 1425 + 1100 + 1320 = 6075
Then Excel divides by how many numbers exist:
6075 ÷ 5 = 1215
Excel performs both steps instantly.
How to Average Multiple Ranges
You can average values from more than one range.
Example:
=AVERAGE(B2:B6, C2:C6)
This averages both ranges together.
How to Average Individual Numbers
You can average numbers directly inside the formula.
Example:
=AVERAGE(10,20,30)
Excel returns:
20
This method is useful for quick calculations.
Important Things to Know About the AVERAGE Function
Understanding these behaviors will help you avoid mistakes.
AVERAGE Ignores Blank Cells
Blank cells are not counted.
AVERAGE Includes Zero Values
Zero counts as a number.
This can lower your average.
AVERAGE Ignores Text
Text values are ignored.
Common Errors When Using AVERAGE
Error 1 — Numbers Stored as Text
Excel may ignore numbers stored as text.
Fix:
Convert text to numbers.
Error 2 — Using Incorrect Ranges
Selecting wrong cells leads to incorrect averages.
Fix:
Always verify highlighted cells.
Error 3 — Unexpected Zeros
Zeros reduce averages.
Fix:
Check for unintended zero values.
Real-World Uses for the AVERAGE Function
The AVERAGE function is widely used in everyday Excel tasks.
Common uses include:
• Calculating average monthly sales
• Finding average student grades
• Tracking average expenses
• Measuring performance metrics
• Analyzing trends over time
AVERAGE is one of the most essential Excel functions.
Download the Practice Workbook
You can download the sample data we’ll be using in this tutorial by clicking on this link —> AVERAGE Function Data
