The AVERAGE function does the math for you

Excel's AVERAGE function adds up a group of numbers and divides by how many numbers there are — the definition of an average. Instead of doing this by hand, you type a formula that tells Excel which cells to use, and it gives you the result in seconds. The formula looks like this: =AVERAGE(A1:A10), which would average whatever numbers sit in cells A1 through A10.

You do not need to understand the math behind it. You just need to know which cells hold the numbers you want to average, then type the formula into any empty cell. Excel handles the rest.

Key Takeaways

  • The AVERAGE function works by typing =AVERAGE(first cell:last cell) into any empty cell, then pressing Enter.
  • You can average a range like A1:A10, or pick individual cells by typing =AVERAGE(A1,A3,A5) with commas between them.
  • The result appears in the cell where you typed the formula, and updates automatically if any of the numbers in your range change.
  • Excel ignores empty cells and text when calculating an average — it only counts actual numbers.

How to type the formula into a cell

Click on any empty cell where you want the average to appear. This is usually below or to the right of the numbers you are averaging. Type the equals sign first — that tells Excel you are entering a formula, not just text.

Then type AVERAGE, followed by an opening parenthesis. Inside the parenthesis, type the range of cells you want to average. If your numbers are in cells A1 through A10, type A1:A10. The colon means "through" — it includes every cell from the first one to the last one. Close with a parenthesis, then press Enter. The average appears in the cell.

The full formula looks like this: =AVERAGE(A1:A10). You can type it in uppercase or lowercase — Excel understands both.

Averaging non-consecutive cells

Sometimes the numbers you want to average are not next to each other. Maybe you want to average cells A1, A3, and A7, but skip A2, A4, A5, and A6. Instead of using a colon, use commas to separate each cell.

Type =AVERAGE(A1,A3,A7) and press Enter. Excel adds those three numbers and divides by three. You can mix ranges and individual cells too: =AVERAGE(A1:A5,A10,A15:A20) would average cells A1 through A5, plus A10, plus A15 through A20.

What happens when you change a number

The average updates automatically. If you typed =AVERAGE(A1:A10) into cell B1, and then you change the number in A5, the average in B1 recalculates when ready. You do not have to type the formula again.

This is one of the main reasons to use a spreadsheet instead of a calculator. You can build a formula once, then change the underlying numbers as many times as you need, and the result stays correct.

How Excel handles empty cells and text

Excel ignores empty cells when calculating an average. If you type =AVERAGE(A1:A10) and cells A3 and A7 are blank, Excel only counts the eight cells that have numbers in them. It divides the sum by eight, not ten.

Excel also ignores cells that contain text. If A5 contains the word "missing" instead of a number, it skips that cell and counts only the numeric cells. This is useful when you have a column with some missing data — you do not have to delete the row or manually exclude it from your formula.

Finding the average of a whole column or row

You can average an entire column or row without typing out every single cell. Type =AVERAGE(A:A) to average all numbers in column A, or =AVERAGE(1:1) to average all numbers in row 1. Excel counts only the cells with numbers and ignores the rest.

Be careful with this approach if your spreadsheet has headers or labels. If row 1 contains the word "Sales" in cell A1, Excel ignores it and only counts the numbers below. But if you have text mixed in with numbers elsewhere in the column, you might get unexpected results. It is usually safer to specify the exact range you want, like =AVERAGE(A2:A100), so you know exactly what is being counted.

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. For example, =AVERAGE(Sheet2!A1:A10) averages cells A1 through A10 on Sheet2. If the sheet name has spaces, put it in single quotes: =AVERAGE('Sales Data'!A1:A10).

What if all the cells I am averaging are empty or contain only text?

Excel shows a #DIV/0! error, which means "division by zero." This happens because there are no numbers to average. Check that your range includes at least one cell with a number in it, or that you typed the cell references correctly.

Does AVERAGE round the result, or show the exact decimal?

Excel shows the exact decimal result. If the average is 7.333333..., that is what appears in the cell. You can change how many decimal places show by right-clicking the cell, choosing Format Cells, and adjusting the decimal places — but this only changes what you see, not the actual number Excel is using in other formulas.

Can I average only numbers that meet a certain condition?

Yes, but you need a different function. =AVERAGEIF(A1:A10,">5") averages only the numbers in A1:A10 that are greater than 5. This is more advanced, but works the same way — type the formula into an empty cell and press Enter.