The AVERAGE function does the math for you

Excel has a built-in function called AVERAGE that calculates the mean — the sum of all your numbers divided by how many numbers there are. You type a formula, point it at your data, and Excel does the division. The result appears in whichever cell you put the formula in.

The mean is useful when you want a single number that represents a typical value in a group. If you have five test scores, the mean tells you what the middle ground looks like. If you have monthly sales figures, the mean shows you the average month.

Key Takeaways

  • The AVERAGE function calculates mean by adding all numbers and dividing by how many numbers exist in your range.
  • Type =AVERAGE(A1:A10) to find the mean of cells A1 through A10, replacing those cell references with your own data location.
  • You can average cells that are next to each other (a range) or cells scattered across the sheet by separating them with commas.
  • Excel ignores empty cells and text when calculating mean, so you do not need to clean up your data first.
  • The formula bar at the top shows you exactly what formula is in a cell, which helps you spot mistakes.

How to type the AVERAGE formula

Click on the cell where you want the mean to appear. This is usually an empty cell below or to the right of your numbers. Type an equals sign to start a formula: =AVERAGE(

Now highlight all the cells that contain the numbers you want to average. If your numbers are in cells A1 through A10, Excel will show you =AVERAGE(A1:A10) as you select them. The colon between A1 and A10 means "all cells from A1 to A10." Press Enter, and Excel calculates the mean and shows it in that cell.

If your numbers are not next to each other — for example, you have data in A1, A3, and A5 but not A2 or A4 — type the cell addresses separated by commas instead: =AVERAGE(A1,A3,A5)

Averaging numbers across multiple columns or rows

The AVERAGE function works the same way whether your numbers run down a column or across a row. If your data is in row 2 from column A to column E, type =AVERAGE(A2:E2) to get the mean of those five cells.

You can also average a rectangular block of cells. If you have a table with numbers in columns A through C and rows 1 through 10, type =AVERAGE(A1:C10) to average all 30 cells at once. Excel adds them all up and divides by 30.

What happens to empty cells and text

Excel ignores empty cells when it calculates mean. If you have the numbers 10, 20, and 30 in cells A1, A2, and A3, but A4 is blank, typing =AVERAGE(A1:A4) still gives you 20 — the mean of the three numbers that exist. Excel does not count the empty cell as a zero.

If a cell contains text instead of a number, Excel skips it too. This means you can include a column header like "Sales" in your range without breaking the formula. Excel sees the text, ignores it, and averages only the numbers.

Checking your formula in the formula bar

After you press Enter, click on the cell with your average to see the formula again. At the top of the screen, the formula bar shows exactly what formula is in that cell. If you see =AVERAGE(A1:A10), you know the formula is looking at the right cells. If you see something different, you can click in the formula bar and edit it without starting over.

The formula bar is also where you spot mistakes. If your average seems wrong, check the formula bar to confirm you are averaging the cells you intended. A common error is typing the wrong cell range — for example, =AVERAGE(A1:A5) when you meant =AVERAGE(A1:A10).

Copying a formula to other cells

Once you have typed the AVERAGE formula in one cell, you can copy it to calculate means for other groups of numbers. Click on the cell with your formula, then copy it (Ctrl+C on Windows, Command+C on Mac). Select the cells where you want the formula to go and paste (Ctrl+V or Command+V).

Excel automatically adjusts the cell references as it pastes. If your original formula was =AVERAGE(A1:A10) and you paste it one row down, it becomes =AVERAGE(A2:A11). This saves time when you need to calculate means for multiple columns or sections of data.

Frequently Asked Questions

Does AVERAGE count zero as a number?

Yes. If a cell contains 0, Excel includes it in the calculation. The mean of 10, 0, and 20 is 10, not 15. If you want to exclude zeros, you need a different formula, but AVERAGE treats zero like any other number.

What is the difference between AVERAGE and AVERAGEIF?

AVERAGE calculates the mean of all numbers in a range. AVERAGEIF calculates the mean of only the numbers that meet a condition you set — for example, only numbers greater than 50, or only cells in a column that match a certain category. AVERAGEIF is more complex but useful when you need a conditional mean.

Can I average cells from different sheets?

Yes. Type the sheet name, then an exclamation point, then the cell range. For example, =AVERAGE(Sheet2!A1:A10) averages cells A1 through A10 on Sheet2. Make sure the sheet name is spelled exactly as it appears on the sheet tab.

Why does my formula show an error like #DIV/0!?

This usually means your range contains no numbers — only text or empty cells. Check that you are pointing at the right cells and that those cells actually contain numbers, not text that looks like numbers.

Can I average only the visible cells if I have hidden rows?

AVERAGE includes hidden rows in its calculation. If you need to average only visible cells, use SUBTOTAL(1,range) instead. The 1 tells Excel to average only cells you can see on screen.