AVERAGE Function
The AVERAGE Function
Calculating the Mathematical Mean of Your Data
The AVERAGE function adds up all the numbers in a range and then divides by the count of those numbers. It is the fastest way to find the "middle" or "typical" value in a list of prices, grades, or sales figures.
Syntax & Example
=AVERAGE(range)
Example: =AVERAGE(C2:C6)
Logic: Excel adds C2+C3+C4+C5+C6 and divides the total by 5.
✅ What it includes
Excel looks at all numerical values in the range. If you change a number, the average updates instantly.
🚫 What it ignores
By default, the AVERAGE function ignores empty cells and cells containing text. It will not let them ruin your calculation.
⚠️ Critical Concept: Zero vs. Blank
Be careful! Excel treats an empty cell as "nothing" (it's ignored), but it treats a 0 as a value.
If a student missed a test, leave the cell blank to keep their average fair. If they scored a 0, type the number, and their average will drop!
💡 Skill Eco Pro-Tip: Visual Verification
Before you trust your formula, highlight the same range and look at the Status Bar at the bottom right. Excel displays the "Average" there automatically. If the numbers match, your formula is correct!
🏋️ Test Yourself With Exercises
Take our quiz on AVERAGE Function to test your knowledge.
Exercise »