AVERAGE Function in Excel
Beginner
Returns the average (arithmetic mean) of the arguments.
Syntax
=AVERAGE(number1, [number2], ...)Example
Use Case
Calculate the average score of a class.
Common Errors to Avoid
- Ignores text and empty cells (can skew results)
- Divides by count of numbers, not total cells in range
- Hidden rows are still included in calculation
Pro Tips
Use AVERAGEIF for conditional averages. For visible cells only, use SUBTOTAL(101,range). Check for outliers that might skew your average using MIN/MAX first.
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →