The fastest way to find a mean in Excel

To find the mean (average) of a set of numbers in Excel, use the AVERAGE function. Type =AVERAGE(, then select or type the cells you want to average, then close the parenthesis and press Enter. For example, if your numbers are in cells A1 through A10, you would type =AVERAGE(A1:A10) and the mean appears in that cell.

The AVERAGE function ignores empty cells and text — it only counts numbers. If you have 10 cells selected but 2 are empty, Excel averages the 8 cells with numbers in them. This is usually what you want, but it matters if you need to know exactly how many values went into your calculation.

Key Takeaways

  • The AVERAGE function calculates mean in one step: type =AVERAGE(A1:A10) in any empty cell and press Enter.
  • You can select cells by clicking and dragging, or type the range directly — both methods work the same way.
  • AVERAGE ignores empty cells and text automatically, so you do not have to clean your data first.
  • If you need to average only cells that meet a condition (like "greater than 50"), use AVERAGEIF instead of AVERAGE.

Selecting the cells you want to average

You have two ways to tell Excel which numbers to average. The first is to click on the first cell, hold down your mouse button, and drag to the last cell you want to include. Release the mouse button. The cells turn blue or highlighted, and the range appears in your formula.

The second way is to type the range directly. If your numbers are in column A from row 1 to row 10, type =AVERAGE(A1:A10). The colon between A1 and A10 means "from A1 to A10, including everything in between." You can also type individual cells separated by commas — =AVERAGE(A1,A3,A5) — if you want to skip some cells.

You can average cells from different parts of your spreadsheet in one formula. Type =AVERAGE(A1:A10,C5:C15) to average two separate ranges at once. Excel adds all the numbers together and divides by how many numbers there are, treating it as one calculation.

Where to put your AVERAGE formula

Click on any empty cell where you want the result to appear. This is usually below or to the right of your data, but it can be anywhere on the sheet. Type your formula there and press Enter. The mean appears in that cell, and the formula stays in the cell — if you click on it later, you see the formula in the formula bar at the top.

If you want to calculate the mean of several different columns, you can put each formula in its own cell. For example, put =AVERAGE(A1:A10) in cell B1, and =AVERAGE(C1:C10) in cell B2. Each cell shows its own mean.

Using AVERAGEIF when you need conditions

Sometimes you want to average only numbers that meet a certain condition — for example, only sales above $500, or only test scores of 80 or higher. The AVERAGEIF function does this. Type =AVERAGEIF(A1:A10,">80") to average only cells in A1:A10 that contain a value greater than 80.

The condition goes in quotes. Use ">80" for greater than, "<80" for less than, "=80" for exactly 80, and "<>80" for anything except 80. You can also use text conditions: =AVERAGEIF(A1:A10,"red") averages only cells that contain the word "red".

If your data and your condition are in different columns, use the three-part version: =AVERAGEIF(B1:B10,">500",A1:A10). This says "look at column B, find cells greater than 500, and average the matching cells in column A." The first range is where you check the condition; the second range is what you actually average.

Common mistakes and how to fix them

The most common mistake is including a cell with text in your range. If you type =AVERAGE(A1:A10) and cell A5 contains the word "total" instead of a number, Excel ignores that cell and averages the rest. This is usually fine, but if you expected 10 numbers and only 9 are being averaged, check for text or empty cells.

Another mistake is forgetting the colon between the first and last cell. If you type =AVERAGE(A1 A10) without the colon, Excel shows an error. The colon tells Excel you want a range; without it, Excel does not understand what you mean.

If your formula shows an error like #DIV/0!, it usually means you selected cells with no numbers in them at all. Check that your range includes at least one number. If your formula shows #NAME?, you may have misspelled AVERAGE — check the spelling and try again.

Copying your formula to other cells

If you need to calculate the mean for multiple columns or sections of data, you can copy your formula instead of typing it each time. Click on the cell with your formula, then press Ctrl+C (or Cmd+C on Mac) to copy. Click on the cell where you want the copy to go and press Ctrl+V (or Cmd+V on Mac) to paste.

Excel automatically adjusts the cell references when you copy. If you copy =AVERAGE(A1:A10) from cell B1 to cell B2, it becomes =AVERAGE(A2:A11) — the range shifts down one row. If you want the range to stay the same when you copy, add dollar signs: =AVERAGE($A$1:$A$10). The dollar signs lock the range so it does not change.

Frequently Asked Questions

What is the difference between AVERAGE and AVERAGEA?

AVERAGE counts only cells with numbers. AVERAGEA counts cells with numbers and treats text and empty cells as zero. In most cases, use AVERAGE. Use AVERAGEA only if you specifically want empty cells or text to count as zero in your calculation.

Can I average cells across multiple sheets?

Yes. Type =AVERAGE(Sheet1.A1:A10,Sheet2.A1:A10) to average ranges from different sheets in the same workbook. Use the sheet name, a period, and the cell range. If your sheet name has a space, put it in single quotes: =AVERAGE('Sheet 1'.A1:A10).

Why does my AVERAGE formula show a different result after I delete a row?

When you delete a row, Excel removes that row from the spreadsheet entirely. If that row was inside your range, it no longer counts toward the average, so the result changes. If you want to exclude a row without changing your average, clear the cell instead of deleting the row.

How do I average only the top 5 values in a column?

Use the LARGE function inside AVERAGE: =AVERAGE(LARGE(A1:A100,ROW(1:5))) and press Ctrl+Shift+Enter instead of just Enter. This is an advanced formula. For simpler cases, sort your data and use AVERAGE on just the top 5 cells.