The simplest way to average numbers in Excel

To average a group of numbers in Excel, type =AVERAGE() into an empty cell, put the range of cells you want to average inside the parentheses, and press Enter. For example, if your numbers are in cells A1 through A10, you would type =AVERAGE(A1:A10) and the average appears when ready in that cell.

Excel does the math for you — it adds all the numbers together and divides by how many numbers there are. You do not have to count the cells or do any calculation yourself. If you change any of the numbers in that range later, the average updates automatically.

The colon between A1 and A10 tells Excel to include every cell in that span. If your numbers are scattered across cells that are not next to each other, you can list them separately with commas instead: =AVERAGE(A1,A3,A5) would average only those three cells, skipping A2 and A4.

Key Takeaways

  • Type =AVERAGE() with the cell range in parentheses to get an when ready average of any group of numbers.
  • Use a colon to include a continuous range (A1:A10) or commas to pick specific cells that are not next to each other (A1,A3,A5).
  • The average recalculates automatically if you change any of the numbers in the range.
  • Excel ignores empty cells and text when calculating an average, so you do not have to clean up your data first.

Where to put the AVERAGE formula

Click on any empty cell where you want the result to appear. This is usually a cell below or to the right of the numbers you are averaging, so it is straightforward to see which calculation goes with which data. Then type the formula and press Enter.

The cell you choose does not matter — Excel only cares about the range inside the parentheses. If you put the formula in cell B5, that is where the average shows up. If you later decide you want it in cell C10 instead, you can cut and paste the formula to the new location and it still works the same way.

Averaging numbers in different layouts

If your numbers run down a column, use the column letter and the row numbers: =AVERAGE(A1:A50) averages cells A1 through A50. If they run across a row from left to right, use the same format but with the row staying the same: =AVERAGE(A1:E1) averages cells A1 through E1.

You can also average numbers that form a rectangle. If your data fills cells A1 through D10 (four columns and ten rows), type =AVERAGE(A1:D10) and Excel averages all 40 cells at once. This is useful when you have a table of numbers and want one average for the whole thing.

If your numbers are in multiple separate areas — for example, column A and column C but not column B — use commas to separate them: =AVERAGE(A1:A10,C1:C10). This tells Excel to average the first range, then the second range, all together.

What happens when your data has blanks or text

Excel skips empty cells automatically. If you have numbers in A1, A2, A4, and A5 but A3 is blank, =AVERAGE(A1:A5) only divides by 4, not 5. This is usually what you want — it does not penalize you for having a gap in your data.

If a cell contains text instead of a number, Excel ignores it too. So if A1 says "Sales" as a header and A2 through A10 contain numbers, =AVERAGE(A1:A10) averages only the nine cells with numbers. You do not have to delete the header or clean up your data before averaging.

The one exception is if a cell contains something that looks like a number but is actually stored as text — for example, if you typed a number with an apostrophe before it. Excel will skip that cell. If you notice your average seems too low, check whether any cells in your range have text that looks like numbers.

Copying a formula down to multiple rows

If you have several groups of numbers and want to average each group separately, you can type the formula once and then copy it down. Type =AVERAGE(A1:A10) in cell B1, then click on B1 and drag the small square in the bottom right corner of the cell down to B5. Excel automatically adjusts the formula for each row — B2 becomes =AVERAGE(A2:A11), B3 becomes =AVERAGE(A3:A12), and so on.

This saves time when you have many groups to average. Excel is smart enough to shift the range down by the same number of rows each time. If you want the formula to always reference the exact same cells (for example, always A1:A10 no matter where you copy it), you can lock those cells by typing dollar signs: =AVERAGE($A$1:$A$10). Then when you copy it, the range stays the same.

Using AVERAGE with other formulas

You can combine AVERAGE with other Excel functions to do more complex calculations. For example, =AVERAGE(A1:A10)*1.1 calculates the average and then multiplies it by 1.1 (useful if you want to increase a number by 10 percent). Or =ROUND(AVERAGE(A1:A10),2) calculates the average and rounds it to two decimal places.

You can also use AVERAGE inside an IF statement to do different things based on whether the average is above or below a certain number. These combinations are more advanced, but they all start with the same basic AVERAGE formula — once you are comfortable with that, you can build on it.

Frequently Asked Questions

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

Yes. Type the sheet name, then an exclamation point, then the cell range: =AVERAGE(Sheet2!A1:A10). If the sheet name has a space in it, put the name in single quotes: =AVERAGE('Sheet 2'!A1:A10). Excel treats it the same as averaging cells on the current sheet.

What is the difference between AVERAGE and AVERAGEIF?

AVERAGE adds up all numbers in a range and divides by how many there are. AVERAGEIF lets you average only the numbers that meet a condition — for example, =AVERAGEIF(A1:A10,">50") averages only the numbers greater than 50. Use AVERAGEIF when you want to exclude certain numbers from the calculation.

Why does my average look wrong?

Check whether any cells in your range contain text or are formatted as text instead of numbers. Excel skips those cells, which can make the average seem lower than expected. Also verify that you are using a colon (A1:A10) not a comma (A1,A10) if you want a continuous range — a comma means only those two specific cells.

Can I average only the visible cells if some rows are hidden?

AVERAGE includes hidden cells. If you want to average only the cells you can see on screen, use =SUBTOTAL(1,A1:A10) instead. The number 1 tells Excel to average only visible cells and ignore hidden ones.