Need to find the mean of a set of numbers? AVERAGE adds up all the values and divides by the count. It’s the foundation for analyzing trends, comparing performance, and understanding your data at a glance.
What Makes AVERAGE Useful
AVERAGE gives you the big picture fast:
- Quick analysis – Understand typical values in seconds
- Ignores text – Automatically skips non-numeric cells
- Flexible ranges – Work with any number of cells or ranges
- Performance tracking – Monitor sales, scores, or metrics over time
- Comparison baseline – See which values are above or below average
The Syntax
=AVERAGE(number1, [number2], ...)You can include individual cells, ranges, or mix both. AVERAGE handles up to 255 arguments.
Example 1: Basic Sales Average
Find the average daily sales:
| Day | Sales |
|---|---|
| Monday | $450 |
| Tuesday | $520 |
| Wednesday | $380 |
| Thursday | $610 |
| Friday | $720 |
Formula: =AVERAGE(B2:B6)
Result: $536
Add all five values and divide by 5. One formula gives you the typical daily performance.
Example 2: Multiple Ranges
Calculate average scores across two test columns:
| Student | Test 1 | Test 2 |
|---|---|---|
| Alice | 85 | 92 |
| Bob | 78 | 84 |
| Carol | 91 | 88 |
Formula: =AVERAGE(B2:B4, C2:C4)
Result: 86.33
AVERAGE combines both ranges into one calculation. All six scores averaged together.
Example 3: Mixed Arguments
Average specific cells plus a range:
| Month | Revenue |
|---|---|
| Jan | $12,500 |
| Feb | $14,200 |
| Mar | $13,800 |
| Apr | $15,600 |
Formula: =AVERAGE(B2, B4, B5:B5)
Result: $13,966.67
Include Jan, Mar, and Apr only. Skip Feb by not referencing B3.
Example 4: Handling Text and Blanks
What happens with mixed data?
| Product | Units Sold |
|---|---|
| Widget A | 45 |
| Widget B | N/A |
| Widget C | 62 |
| Widget D | |
| Widget E | 38 |
Formula: =AVERAGE(B2:B6)
Result: 48.33
AVERAGE ignores “N/A” and the blank cell. It only averages the three numeric values: 45, 62, and 38.
Example 5: Department Performance
Compare individual performance to team average:
| Employee | Sales |
|---|---|
| Sarah | $8,500 |
| Mike | $12,300 |
| Jennifer | $9,800 |
| Tom | $11,200 |
Formula in C2: =B2-$B$2:$B$5 won’t work, but this will:
Formula: =AVERAGE($B$2:$B$5)
Result: $10,450
Use absolute references (dollar signs) when you want to copy the formula down but keep the same average range.
Example 6: Quarterly Trend Analysis
Find average sales per quarter:
| Q1 | Q2 | Q3 | Q4 | |
|---|---|---|---|---|
| 2024 | $125K | $138K | $145K | $162K |
| 2025 | $142K | $156K | $168K |
Formula for 2024: =AVERAGE(B2:E2)
Result: $142.5K
Formula for 2025: =AVERAGE(B3:E3)
Result: $155.33K
The blank Q4 cell for 2025 is ignored. Average calculates based on three quarters only.
Common Mistakes to Avoid
Counting vs Averaging
=AVERAGE(B2:B10)finds the mean=COUNT(B2:B10)counts how many numbers exist- These are different things
Zero vs Blank
- Blank cells are ignored
- Cells with 0 are included in the calculation
- This affects your results
Text Numbers
- Numbers stored as text (with an apostrophe or from imports) are ignored
- Convert text to numbers first if needed
When to Use AVERAGE
Use AVERAGE when:
- You need the typical or middle value
- You’re tracking performance over time
- You’re comparing against a baseline
- You want to smooth out variations
Don’t use AVERAGE when:
- You have extreme outliers (use MEDIAN instead)
- You need the most common value (use MODE instead)
- You need weighted averages (use SUMPRODUCT or AVERAGEIF)
Start Using It
Open any spreadsheet with numbers. Select a range. Type =AVERAGE and include your cells. Hit enter. That’s it.
AVERAGE becomes automatic once you start analyzing data regularly.
Questions about AVERAGE? Want to explore weighted averages or conditional averaging? Let’s connect.