# AVERAGE function in Excel

> AVERAGE adds up the numbers you give it and divides by how many numbers there are.

Source: https://spreadsheetpractice.com/functions/average · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** AVERAGE adds up the numbers you give it and divides by how many numbers there are.
- **Syntax:** `=AVERAGE(number1, [number2], ...)`
- **Most common use:** `=AVERAGE(B2:B7)` returns 35.6 (Week 3's zero counts; the empty week 6 is skipped)
- **Available in:** Every current version
- **Category:** [Statistical functions](https://spreadsheetpractice.com/functions/category/stats)
- **Returns:** The arithmetic mean of the numbers, or #DIV/0! if there are no numbers to average.
- **Google Sheets:** Also available in Google Sheets.

## What it does

AVERAGE adds up the numbers you give it and divides by how many numbers there are. Inside a range it skips empty cells and text but counts zeros, so a week with 0 sales pulls the average down while a week that hasn't been entered yet doesn't.

## Syntax

`=AVERAGE(number1, [number2], ...)`

| Argument | Required? | What it is |
|---|---|---|
| `number1` | Required | The first number, cell or range to average. |
| `number2` | Optional | More numbers, cells or ranges, up to 255 in total. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=AVERAGE(B2:B7)` | 35.6 | Week 3's zero counts; the empty week 6 is skipped |
| F3 | `=AVERAGE(B2:B3,B5:B6)` | 44.5 | Two ranges in one formula leave out week 3 |
| F4 | `=ROUND(AVERAGE(B2:B7),0)` | 36 | Rounded to a whole number for a report |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Week | Tickets |  |  | Average | Result |
| 2 | Week 1 | 42 |  |  | All weeks | 35.6 |
| 3 | Week 2 | 38 |  |  | Skip week 3 | 44.5 |
| 4 | Week 3 | 0 |  |  | Rounded | 36 |
| 5 | Week 4 | 51 |  |  |  |  |
| 6 | Week 5 | 47 |  |  |  |  |
| 7 | Week 6 |  |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| The average is lower than expected | Zeros are included. If a 0 means "no data yet", leave the cell empty or use AVERAGEIF(range,"<>0"). |
| #DIV/0! | There are no numbers in the range, often because the values are stored as text. Convert them with VALUE or Text to Columns. |
| Numbers typed as text are ignored | Values pasted from another system can look like numbers but sit left-aligned as text. AVERAGE skips them silently. |

## Tips

- To average only some rows, use AVERAGEIF or AVERAGEIFS instead of building the list by hand.
- The status bar shows the average of any selected cells, which is a quick way to check a formula.

## Related functions

- [MEDIAN](https://spreadsheetpractice.com/functions/median): MEDIAN returns the middle value once the numbers are sorted.
- [AVERAGEIF](https://spreadsheetpractice.com/functions/averageif): AVERAGEIF averages only the values that meet one condition: the average order from one region, response times for chat tickets, scores above zero.
- [AVERAGEIFS](https://spreadsheetpractice.com/functions/averageifs): AVERAGEIFS averages the values where every condition is true, such as Algebra scores from the fall term or passing scores only.
- [SUM](https://spreadsheetpractice.com/functions/sum): SUM adds numbers.

## Questions

### Does AVERAGE ignore blank cells?

Yes. Empty cells inside a range are skipped, so they don't count toward the divisor. Cells containing 0 are counted.

### How do I average and ignore zeros?

Use =AVERAGEIF(B2:B7,"<>0"). It averages only the cells that aren't zero.

### What is the difference between AVERAGE and MEDIAN?

AVERAGE is the sum divided by the count. MEDIAN is the middle value, which is better when a few extreme numbers would distort the average.

## Practice

A graded AVERAGE exercise ("Average, best and worst") is on [the AVERAGE page](https://spreadsheetpractice.com/functions/average). It is checked instantly, then re-checked on changed data.

Lessons that use AVERAGE:

- [Lesson 2: SUM, AVERAGE, MIN, MAX & COUNT](https://spreadsheetpractice.com/learn/sum-average-min-max-count)
- [Lesson 28: LET](https://spreadsheetpractice.com/learn/let-function) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
