The simplest way to find an average in Excel

To calculate the average (also called the mean) of a group of numbers in Excel, use the AVERAGE function. Type =AVERAGE( followed by the cells you want to average, then close with ). For example, if your numbers are in cells A1 through A10, you would type =AVERAGE(A1:A10) and press Enter. Excel does the math and shows you the result in that cell.

The AVERAGE function works the same way whether you have 5 numbers or 500. Excel adds them all up and divides by how many numbers there are — that's what a mean is. You do not have to do the math yourself or count the cells; Excel handles both parts.

Key Takeaways

  • Type =AVERAGE(A1:A10) to find the mean of cells A1 through A10, replacing those cell references with the ones that hold your numbers.
  • The colon between two cell names (like A1:A10) tells Excel to include every cell in that range, not just those two.
  • You can average cells that are not next to each other by separating them with commas, like =AVERAGE(A1,A5,A9).
  • Excel ignores empty cells and text when calculating the mean, so you do not have to clean up your data first.
  • If you need to see the calculation step-by-step, you can click on the cell with the formula and look at the formula bar at the top of the screen.

Selecting a range of cells to average

When your numbers sit in a row or column next to each other, use a range. A range is two cell names separated by a colon. For example, A1:A10 means "every cell from A1 to A10." You type this inside the AVERAGE function: =AVERAGE(A1:A10).

To find the right range, look at where your first number is and where your last number is. If your numbers start in cell B2 and end in cell B15, your range is B2:B15. The order does not matter — you can write A10:A1 and Excel will still average the same cells, though it is clearer to write the smaller number first.

You can also select the range by clicking and dragging. Click on the first cell with a number, hold down the mouse button, drag to the last cell, and release. Excel shows you which cells are selected by highlighting them in blue. Then type your formula and press Enter.

Averaging cells that are not next to each other

Sometimes your numbers are scattered across the spreadsheet. You might have data in A1, A5, and A9, with other information in between. To average only those three cells, separate them with commas inside the AVERAGE function: =AVERAGE(A1,A5,A9).

You can mix ranges and individual cells in the same formula. For example, =AVERAGE(A1:A5,C2,D1:D10) would average cells A1 through A5, plus cell C2, plus cells D1 through D10. This is useful when you have some numbers grouped together and others separate.

What Excel ignores when calculating the mean

Excel automatically skips over empty cells, so you do not have to delete blank rows before using AVERAGE. If you have numbers in A1, A2, A4, and A5 (with A3 empty), =AVERAGE(A1:A5) will average only the four cells with numbers. It divides the sum by 4, not by 5.

Excel also ignores cells that contain text. If you have a column with numbers and one cell says "Total" or "N/A", AVERAGE will skip it. This means you can safely use AVERAGE on a range that has labels or notes mixed in, as long as the labels are text and not numbers.

However, if a cell contains text that looks like a number (like the number stored as text instead of as a value), Excel may or may not include it depending on how it was entered. When in doubt, check your result by counting how many cells were actually used — you can see this in the status bar at the bottom of the screen, which shows "Average" when you select a range.

Finding the mean of a column or row you just created

If you have just typed numbers into a column and want to see their average right away, select all the cells with numbers. Look at the bottom right of your screen — Excel shows you the average, sum, and count of the selected cells without you having to type a formula. This is a quick way to check your work or see a one-time average without storing it in a cell.

To keep the average in your spreadsheet so you can see it later, click on an empty cell below or beside your numbers and type the AVERAGE formula. This stores the result in that cell, and you can reference it in other formulas or print it with your data.

Using AVERAGE with other functions

You can combine AVERAGE with other Excel functions to solve more complex problems. For example, =AVERAGE(IF(A1:A10>5,A1:A10)) would average only the numbers greater than 5 (though this requires pressing Ctrl+Shift+Enter instead of just Enter). For most everyday tasks, a straightforward AVERAGE formula is enough.

If you need to average numbers based on a condition — like averaging only sales from a certain month or only scores above a threshold — look into the AVERAGEIF function. It works similarly to AVERAGE but lets you set a rule for which cells to include. The syntax is =AVERAGEIF(range, criteria), where range is the cells to check and criteria is the rule (like ">5" or "January").

Frequently Asked Questions

What is the difference between AVERAGE and SUM?

SUM adds all the numbers together and shows the total. AVERAGE adds them and divides by how many numbers there are, giving you the mean. If you have 10 and 20, SUM gives 30 and AVERAGE gives 15.

Can I average numbers from different sheets in the same workbook?

Yes. Type the sheet name, an exclamation mark, and the cell range: =AVERAGE(Sheet2!A1:A10). Replace "Sheet2" with the actual name of the sheet and A1:A10 with your range. Excel will calculate the average across sheets.

Why does my AVERAGE formula show an error?

The most common cause is a typo in the cell range or a missing closing parenthesis. Check that you typed the formula exactly, with no spaces inside the parentheses. If cells contain text instead of numbers, AVERAGE will ignore them — this is not an error, just how the function works.

How do I average only the visible cells if I have hidden rows?

Use the SUBTOTAL function instead: =SUBTOTAL(1,A1:A10). The number 1 tells SUBTOTAL to average only visible cells. AVERAGE includes hidden cells, so SUBTOTAL is the right choice when you have filtered or hidden data.

Can I average cells and also see the calculation in the cell?

The cell shows only the result, not the formula. To see the formula, click on the cell and look at the formula bar at the top of the screen — it displays the full formula there. You can also press Ctrl+` (backtick) to toggle between showing formulas and showing results in all cells.