# How to Calculate the Mean in Excel (Step by Step)

To find the mean in Excel, type `=AVERAGE(` and select the cells you want to average, then press Enter. Excel adds the values and divides by the count of numeric cells in that range. The result appears in the cell where you entered the formula, and it updates automatically whenever the source numbers change.

## Quick Answer

- The mean is the sum of your values divided by how many values you have: $\bar{x} = \frac{\sum x_i}{n}$.
- Use `=AVERAGE(A2:A10)` to average a column of numbers.
- `AVERAGE` ignores blank cells and cells containing text, but it does count cells containing zero.
- Use `=AVERAGEIF(range, criteria, average_range)` when you only want the mean of a subset.
- If you see `#DIV/0!`, the range contains no numeric values at all.

## Before You Start

Excel gives you several functions that look similar but behave differently. Knowing which one you need prevents most errors before they happen.

| Function | What it does | Counts blanks? | Counts text? |
|---|---|---|---|
| `AVERAGE` | Sum divided by count of numeric cells | No | No |
| `AVERAGEA` | Sum divided by count of non-empty cells | No | Yes, as 0 |
| `AVERAGEIF` | Mean of cells meeting one condition | No | No |
| `AVERAGEIFS` | Mean of cells meeting multiple conditions | No | No |
| `MEDIAN` | Middle value | No | No |

The distinction matters. If a column has ten rows but only six contain numbers, `AVERAGE` divides by 6, while `AVERAGEA` divides by 10 and treats the text entries as zeros. That single choice can shift your result substantially, so decide deliberately which denominator you want.

Good spreadsheet practice also helps here. Keeping one variable per column, with a single header row and no merged cells, makes ranges predictable and formulas easier to audit [1].

## Step by Step

1. **Put your numbers in a single column or row.** For example, enter values in cells A2 through A10, with a label such as "Scores" in A1.

2. **Click the cell where you want the mean to appear.** Leave at least one empty cell between your data and the result so the formula range stays clear.

3. **Type the formula.** Start with an equals sign, then the function name and an opening parenthesis:

   ```
   =AVERAGE(A2:A10)
   ```

4. **Select the range with the mouse if you prefer.** Type `=AVERAGE(`, then drag from A2 to A10. Excel inserts the range reference for you.

5. **Close the parenthesis and press Enter.** The cell now shows the arithmetic mean of the values in A2:A10.

6. **Check the result against a quick estimate.** Multiply the mean by the number of values and confirm the product is close to the sum of your data. This catches a range that is one row too short or too long.

7. **Copy the formula down or across if needed.** Drag the fill handle to apply the same pattern to other columns. Relative references adjust automatically.

If you are new to writing formulas, the mechanics of operators, cell references, and parentheses are covered in [how to make a formula in Excel](/blog/data-analysis/how-to-make-formula-in-excel).

## Worked Example

Suppose you are averaging the daily number of support tickets closed by one agent over a short week, and the values in cells B2 through B6 are 2, 3, 5, 4, and 6.

The formula is:

```
=AVERAGE(B2:B6)
```

The sum is $2 + 3 + 5 + 4 + 6 = 20$, and there are five values, so the mean is $20 \div 5 = 4$. Excel returns 4.

Now delete the value 6 from B6. The sum becomes 14 and the count becomes 4, so the mean changes to 3.5. This shows the two moving parts of the calculation: both the numerator and the denominator respond to your data.

If you want to see the mean, median, and mode side by side without opening a spreadsheet, the [Mean, Median & Mode Calculator](/tools/mean-median-mode-calculator) does the arithmetic for you.

## Other Ways to Do It

**The status bar.** Select a range of numbers and look at the bottom of the Excel window. Excel displays the average, count, and sum of the selection automatically. This is the fastest way to check a value without writing a formula.

**The AutoSum dropdown.** On the Home tab, the AutoSum button has a dropdown arrow. Choosing Average inserts an `AVERAGE` formula for the adjacent range, which you can then adjust.

**AVERAGEIF for one condition.** To average only the values above a threshold:

```
=AVERAGEIF(A2:A10,">50")
```

The first argument is the range to test, the second is the condition, and the optional third argument is the range to average when it differs from the first.

**AVERAGEIFS for multiple conditions.** To average sales in a region during a specific month:

```
=AVERAGEIFS(C2:C100,A2:A100,"North",B2:B100,"March")
```

Each criteria range is paired with its condition. All conditions must be met for a row to count.

**SUMPRODUCT for weighted means.** When each value carries a different weight, a plain average is wrong. Use:

$$ \bar{x}_w = \frac{\sum w_i x_i}{\sum w_i} $$

In Excel that becomes `=SUMPRODUCT(values,weights)/SUM(weights)`. A weighted mean answers a different question than `AVERAGE`, so label it clearly.

**The Analysis ToolPak.** The Descriptive Statistics tool reports the mean along with standard error, median, mode, standard deviation, and more in one table. It is useful when you want a full summary instead of a single number. Once you have the mean, the next step is usually spread, which is covered in [how to calculate standard deviation in Excel](/blog/data-analysis/how-to-calculate-standard-deviation-in-excel) and [how to calculate variance in Excel](/blog/data-analysis/how-to-calculate-variance-in-excel).

## Troubleshooting

**`#DIV/0!`** means the range contains no numbers. Check for stray spaces, numbers stored as text, or a range that points at the wrong column.

**`#VALUE!`** usually means one of the arguments is text that Excel cannot interpret. Verify that every cell in the range holds a real number.

**`#NAME?`** means the function name is misspelled or the function is unavailable. Check the spelling of `AVERAGE` and confirm the workbook is not in an older file format that lacks the function.

**Numbers stored as text.** A value that looks like a number but is left-aligned is probably text. It will be ignored by `AVERAGE`. Convert it with Text to Columns or by multiplying by 1 in a helper column.

**A wrong-looking result.** Click the cell and look at the formula bar. A range like `A2:A100` that includes empty rows below your data is fine, but a range that starts one row too low silently drops your first value.

**Hidden rows.** `AVERAGE` includes values in hidden rows and columns. If you filtered the data, use `SUBTOTAL(101,range)` to average only the visible cells.

## Common Mistakes

- **Averaging percentages directly.** The mean of percentages is not the overall percentage unless every group has the same size. Weight each percentage by its group size, or average the underlying counts and divide.
- **Including a total row in the range.** If row 11 holds a sum of rows 2 through 10, `=AVERAGE(A2:A11)` counts that total as a data point and inflates the result. Exclude summary rows from every range.
- **Confusing blank cells with zeros.** A blank cell is skipped, a zero is counted. If a missing measurement was entered as 0, your mean is too low. Leave genuinely missing values empty.
- **Using `AVERAGEA` without meaning to.** It counts text and logical values, treating text as zero and TRUE as 1. Use it only when that behavior is what you want.
- **Assuming the mean describes a typical value.** With a skewed distribution or outliers, the mean can sit far from most of the data. Compare it with the median using [how to calculate median in Excel](/blog/data-analysis/how-to-calculate-median-in-excel).
- **Forgetting that the mean is sensitive to every value.** One mistyped digit changes the result. Sort the column or scan for values far outside the expected range before you report the number.

## Limitations

The mean is a single summary number, and it hides the shape of your data. Two datasets with the same mean can look completely different, one tightly clustered and one spread across a wide range. Always pair the mean with a measure of spread and, for skewed data, with the median.

Excel's arithmetic itself is reliable for ordinary sums and averages, but the accuracy of statistical procedures in Excel has been examined critically in the literature, particularly for distribution functions and some procedures in older versions [2]. For routine descriptive statistics like the mean, the main risks are data entry and range selection, not the arithmetic. Verify your ranges and your data types, and the result will be correct.

## Frequently Asked Questions

### How do I calculate the mean in Excel if my column has blank cells?

`AVERAGE` skips blank cells entirely, so they do not affect the result. If a blank cell should count as zero, enter 0 instead of leaving it empty. If you want the denominator to include blanks, use `AVERAGEA`, but understand that it treats text as zero and logical values as 1 or 0.

### Why does my AVERAGE formula give a different number than I expect?

The most common causes are a range that includes a total row, numbers stored as text, or a range that is one row short. Click the cell, inspect the range in the formula bar, and compare the count of numeric cells with the count you expect. `=COUNT(range)` tells you how many numeric cells Excel actually sees.

### How do you calculate the mean of only some rows in Excel?

Use `AVERAGEIF` for one condition or `AVERAGEIFS` for several. For example, `=AVERAGEIF(B2:B100,"East",C2:C100)` averages column C only for rows where column B equals "East". The criteria can be a number, text, or a comparison such as `">=100"`.

### Can I average a column that contains error values?

No. A single `#N/A` or `#DIV/0!` in the range makes the whole `AVERAGE` formula return that error. Clean the errors first, or wrap the calculation in `AGGREGATE`, which can ignore error values and hidden rows while still computing the mean.

### What is the difference between mean and average in Excel?

In everyday use they are the same thing, and Excel's `AVERAGE` function computes the arithmetic mean. In statistics, "average" can refer to several measures of central tendency, including the mean, median, and mode. When you report a number, say which one you used so readers are not misled.

## References

1. [Broman KW, Woo KH (2018). Data Organization in Spreadsheets. The American Statistician](https://doi.org/10.1080/00031305.2017.1375989)
2. [McCullough B, Heiser DA (2008). On the accuracy of statistical procedures in Microsoft Excel 2007. Computational Statistics & Data Analysis](https://doi.org/10.1016/j.csda.2008.03.004)

## Further Reading

- [Ziemann M, Eren Y, El-Osta A (2016). Gene name errors are widespread in the scientific literature. Genome Biology](https://doi.org/10.1186/s13059-016-1044-7)
- [Microsoft Support: Excel help and learning](https://support.microsoft.com/en-us/excel)
- [Abeysooriya M, Soria M, Kasu MS et al. (2021). Gene name errors: Lessons not learned. PLOS Computational Biology](https://doi.org/10.1371/journal.pcbi.1008984)
- [Wilson G, Bryan J, Cranston K et al. (2017). Good enough practices in scientific computing. PLOS Computational Biology](https://doi.org/10.1371/journal.pcbi.1005510)

## Related Articles

- [How to Calculate the Mean: Formula and Step by Step Examples](/blog/data-analysis/how-to-calculate-the-mean)
- [How to Calculate Median in Excel (Step by Step)](/blog/data-analysis/how-to-calculate-median-in-excel)
- [How to Calculate Standard Deviation in Excel](/blog/data-analysis/how-to-calculate-standard-deviation-in-excel)
- [How to Calculate Variance in Excel (Step by Step)](/blog/data-analysis/how-to-calculate-variance-in-excel)
- [How to Find Percentage in Excel (Step by Step)](/blog/data-analysis/how-to-find-percentage-in-excel)
- [Test Statistic Formula: How to Calculate and Use It](/blog/guides/test-statistic-formula-how-to-calculate-and-use-it)