How to Calculate the Mean in Excel Using the AVERAGE Function

The AVERAGE function calculates the mean of your numbers

Excel's AVERAGE function adds up all the numbers in a range and divides by how many numbers there are — that is the mean. Type =AVERAGE() into any cell, put your range of numbers inside the parentheses, and press Enter. Excel does the math and shows you the result in that cell.

The mean is useful when you want a single number that represents a typical value in your data. If you have sales figures for twelve months, the mean tells you the average monthly sale. If you have test scores for a class, the mean shows the average performance.

Key Takeaways

The AVERAGE function syntax is =AVERAGE(first cell:last cell), where you replace the cell references with your actual data range.
You can type the range directly (like A1:A10) or click and drag to select cells, and Excel will fill in the range for you.
AVERAGE ignores empty cells and text, so it only counts cells with numbers in them.
If your data is scattered across non-adjacent cells, use commas to separate ranges: =AVERAGE(A1:A5,C1:C5).
The result appears in the cell where you typed the formula, and you can copy that formula down to calculate means for different rows or columns.

Selecting your data range and typing the formula

Click on an empty cell where you want the mean to appear. Type the equals sign first — this tells Excel you are entering a formula, not text. Then type AVERAGE followed by an opening parenthesis.

Now select the cells that contain your numbers. You can type the range directly (for example, A1:A10 means cells A1 through A10 in column A) or click on the first cell and drag to the last cell. Excel highlights the selected range in color as you drag. When you have selected all the cells you need, type the closing parenthesis and press Enter.

The mean appears in the cell when ready. If you made a mistake, click the cell again and look at the formula bar at the top — it shows your formula so you can edit it.

Working with data in different layouts

If your numbers are in a single column, the range is straightforward: =AVERAGE(A1:A20) calculates the mean of twenty cells stacked vertically. If your numbers are in a single row, use the same method but with row letters: =AVERAGE(A1:T1) calculates the mean across columns A through T in row 1.

When your data is scattered in separate groups, use commas to separate the ranges. For example, =AVERAGE(A1:A5,C1:C5,E1:E5) calculates the mean of three separate blocks of cells. This is useful when you have data in columns A, C, and E but want to skip column B.

You can also mix single cells and ranges. The formula =AVERAGE(A1,A3:A10,B5) includes cell A1, cells A3 through A10, and cell B5 in one calculation.

Copying the formula to other cells

Once you have entered the formula in one cell, you can copy it to calculate means for other rows or columns without retyping. Click the cell containing your formula, then press Ctrl+C (or Cmd+C on Mac) to copy it.

Select the cells where you want the formula to appear — you can click and drag to select multiple cells at once. Press Ctrl+V (or Cmd+V on Mac) to paste. Excel automatically adjusts the cell references in each copy. If your original formula was =AVERAGE(A1:A10), pasting it one row down changes it to =AVERAGE(A2:A11), and so on.

This automatic adjustment saves time when you have many columns or rows of data that need the same calculation.

What AVERAGE includes and what it ignores

The AVERAGE function counts only cells that contain numbers. If a cell is empty, AVERAGE skips it. If a cell contains text (like a label or a word), AVERAGE ignores that cell too. This means you can safely include a range that has some empty cells or text mixed in, and the function will still calculate correctly.

For example, if cells A1 through A10 contain the numbers 5, 10, 15, 20, 25, and four empty cells, AVERAGE calculates the mean of only those five numbers: (5+10+15+20+25) ÷ 5 = 15. It does not divide by 10.

If you want to include empty cells as zeros in your calculation, use a different function like AVERAGEIF or enter the zeros yourself before calculating.

Common mistakes and how to fix them

The most common error is forgetting the equals sign at the start. Without it, Excel treats your entry as text and does not calculate anything. Always start with =.

Another mistake is using the wrong cell reference. If you type =AVERAGE(A1:B10) when you meant =AVERAGE(A1:A10), you are including an extra column of data. Check the formula bar to see exactly which cells are included.

If your result looks wrong, verify that all your data is actually numbers. A cell that looks like a number but is stored as text will be ignored. You can also use the AutoSum button on the toolbar — click it, and Excel suggests a range to average, which you can accept or adjust.

Using AVERAGE with other Excel features

You can combine AVERAGE with other functions for more complex calculations. For instance, =AVERAGE(IF(A1:A10>5,A1:A10)) calculates the mean of only the numbers greater than 5 (though this requires pressing Ctrl+Shift+Enter instead of just Enter). The AVERAGEIF function does this more straightforward: =AVERAGEIF(A1:A10,">5").

You can also nest AVERAGE inside other formulas. If you want to round the mean to two decimal places, use =ROUND(AVERAGE(A1:A10),2). The ROUND function takes the result from AVERAGE and rounds it.

These combinations let you tailor the calculation to match exactly what your data needs.

Frequently Asked Questions

Can I calculate the mean of just a few cells instead of a whole range?

Yes. Use commas to separate individual cells: =AVERAGE(A1,A3,A7) calculates the mean of only those three cells. You can mix single cells and ranges in the same formula, like =AVERAGE(A1,A3:A5,B2).

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, =AVERAGEIF(A1:A10,">10") finds the mean of only the numbers greater than 10 in that range.

Does AVERAGE count zero as a number?

Yes. If a cell contains 0, AVERAGE includes it in the calculation. If you want to exclude zeros, use AVERAGEIF with a condition like =AVERAGEIF(A1:A10,"<>0"), which means "not equal to zero".

Why does my AVERAGE formula show an error?

The most common cause is a typo in the function name or cell references. Check that you typed AVERAGE correctly and that your cell range exists. If you see #DIV/0!, the range contains no numbers. If you see #NAME?, Excel does not recognize the function name — make sure it is spelled right.

Can I calculate a running average as I add new data?

Yes. Keep your AVERAGE formula in a cell and update the range as you add rows. For example, if you add a new number to A11, change =AVERAGE(A1:A10) to =AVERAGE(A1:A11). Alternatively, use a large range from the start, like =AVERAGE(A1:A100), and the formula will automatically include new numbers as you enter them in that range.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.