Excel AVERAGE Function (Mean of Numbers) – Examples & Practice
Practice the Excel AVERAGE function online with an interactive grid, instant feedback, and clear formula help.
Instruction
Find the average score in column B from B2 to B6.
Formula Syntax
=AVERAGE(number1, [number2], ...)
- number1: First number, cell, or range.
- [number2]: Optional additional numbers or ranges.
- ...: Up to 255 arguments.
What it does
AVERAGE calculates the arithmetic mean of numbers in a range. It is the standard way to summarize typical values in Excel. Blank cells are ignored; zeros are included like any other number.
Excel AVERAGE Function Examples
Average a column of scores
=AVERAGE(B2:B6)
Returns the mean of numeric values in B2:B6.
Average non-contiguous cells
=AVERAGE(B2, B4, B6)
Averages only the listed cells.
Average with zero included
=AVERAGE(B2:B6)
Zeros count as real values and lower the mean.
quiz-scores.xlsx
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Anna | 8 |
| 3 | Ben | 7 |
| 4 | Chris | 9 |
| 5 | Dana | 6 |
| 6 | Elly | 10 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Plot AVERAGE next to SUM and COUNT to sanity-check your dataset.
- Use MEDIAN when a few extreme values distort the mean.
- Wrap with IFERROR when teaching beginners to avoid scary errors.
AVERAGE Function Use Cases
- Report typical performance (scores, cycle times, ratings)
- Compare regions or reps against a baseline mean
- QC checks when totals are less important than central tendency
- Rolling averages on time series (often combined with OFFSET)
- Dashboard KPIs next to SUM and COUNT
Common mistakes - AVERAGE function not working
- Including text headers inside the numeric range
- Expecting MEDIAN or MODE behavior from AVERAGE
- Averaging rates without weighting (use a weighted approach instead)
- Using AVERAGE on ranges that include error cells (#N/A breaks the result)
- Forgetting that blanks are skipped but zeros are not
FAQ
Does AVERAGE ignore blanks?
Yes. Blank cells are skipped. Text is ignored, but a text cell mixed into a numeric range can still cause issues if coerced unexpectedly.
Is AVERAGE the same as MEDIAN?
No. AVERAGE is the arithmetic mean. MEDIAN is the middle value when data is sorted.
Why is my average wrong?
Hidden rows, numbers stored as text, or including header cells in the range are common causes.
Can AVERAGE divide by zero?
If every value is non-numeric or the range is empty, you may see #DIV/0!. Add IFERROR if you need a friendly fallback.
Does AVERAGE work with TRUE/FALSE?
Logical values are ignored unless the range is entered as an array constant in some cases; keep ranges purely numeric for predictable results.
Comparison
| Function | Result | When to use |
|---|---|---|
| AVERAGE | Mean | Typical middle value |
| MEDIAN | Middle sorted value | Skewed data, outliers |
| MODE | Most frequent | Categorical peaks |
Example
=AVERAGE(B2:B6) for the mean.
=MEDIAN(B2:B6) for the middle value.
Advanced examples
Trimmed mean pattern
Combine AVERAGE with IF logic in older Excel, or FILTER in modern Excel, to drop outliers before averaging.
Rolling window
Pair AVERAGE with OFFSET or dynamic ranges to compute a moving average over the last N periods.