The AVERAGE function finds the middle value of your numbers

Excel's AVERAGE function adds up a group of numbers and divides by how many numbers there are. You type =AVERAGE() with the cells you want to average inside the parentheses, and Excel does the math when ready. This is faster and more reliable than adding numbers by hand, especially when you have dozens or hundreds of entries.

The function works the same way whether you're averaging test scores, monthly sales, temperature readings, or any other numbers. Excel ignores empty cells and text — it counts only the actual numbers in your range.

Key Takeaways

  • Type =AVERAGE(A1:A10) to average cells A1 through A10, or =AVERAGE(A1,A3,A5) to average specific cells that aren't next to each other.
  • Excel automatically ignores empty cells and text when calculating, so you don't need to clean up your data first.
  • The result appears in whichever cell you typed the formula into, and updates automatically if any of the numbers change.
  • You can average a single column, a single row, or a rectangular block of cells — the syntax stays the same.

How to type the AVERAGE formula

Click the cell where you want the average to appear. Type an equals sign to start a formula: =AVERAGE. Then type an opening parenthesis and select the cells you want to average by clicking and dragging, or type the range directly.

If your numbers are in cells A1 through A10, you would type =AVERAGE(A1:A10) and press Enter. The colon between A1 and A10 means "all cells from A1 to A10". Excel calculates the average and shows the result in that cell.

If your numbers aren't in one continuous block — for example, you want to average A1, A3, and A7 but skip A2, A4, A5, and A6 — type =AVERAGE(A1,A3,A7) with commas between each cell. This tells Excel to average only those three specific cells.

Averaging rows, columns, or rectangular blocks

The AVERAGE function works the same way no matter which direction your data runs. If your numbers go down a column, use a colon: =AVERAGE(B2:B50). If they go across a row, use the same syntax: =AVERAGE(C1:H1). If they fill a rectangle — say columns A through D and rows 1 through 20 — type =AVERAGE(A1:D20).

Excel reads the colon as "through", so A1:D20 means every cell from the top-left corner (A1) to the bottom-right corner (D20). You don't need to think about whether the data is arranged horizontally or vertically — the colon notation handles both.

What happens to empty cells and text

Excel ignores empty cells when calculating an average. If you have the numbers 10, 20, and 30 in cells A1, A2, and A3, but A4 is empty, =AVERAGE(A1:A4) still gives you 20 (the average of three numbers, not four). The empty cell doesn't count as zero.

Text entries are also ignored. If a cell contains a label like "Total" or a date, Excel skips it and averages only the numeric values in your range. This means you can include a header row in your selection without breaking the formula — Excel automatically excludes it.

The formula updates when your numbers change

Once you've entered the AVERAGE formula, it stays connected to the cells you selected. If you change any of those numbers, the average recalculates when ready. This is useful when you're tracking ongoing data — like weekly sales or daily temperatures — because you don't have to re-enter the formula each time.

You can also copy the formula to other cells. If you've calculated the average for January in cell C1, you can copy that formula down to C2, C3, and so on. Excel automatically adjusts the cell references, so C2 will average the February data, C3 will average March, and so on.

When to use AVERAGE instead of other functions

Use AVERAGE when you want the middle value of a set of numbers. Use SUM instead if you want the total of all numbers added together. Use COUNT if you just want to know how many numbers are in your range, without adding them up.

If you want the most common number in a list, use MODE. If you want the exact middle value when numbers are arranged from smallest to largest, use MEDIAN. MEDIAN is useful when one very large or very small number would skew the average — for example, if you're averaging salaries and one executive earns far more than everyone else, the median gives a better picture of what a typical employee makes.

Frequently Asked Questions

What's the difference between AVERAGE and MEDIAN?

AVERAGE adds all numbers and divides by how many there are. MEDIAN finds the middle number when you arrange them from smallest to largest. If you have 10, 20, and 100, the average is 43.33 but the median is 20. Use MEDIAN when one very large or very small number would make the average misleading.

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

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

Does AVERAGE count zero as a number or ignore it?

AVERAGE counts zero as a number. If you have 10, 0, and 20, the average is 10. If you want to exclude zeros from your calculation, use AVERAGEIF instead: =AVERAGEIF(A1:A10,">0") averages only the positive numbers.

What if all my cells are empty or contain only text?

Excel shows a #DIV/0! error, which means "division by zero" — there are no numbers to average. Check that your range includes actual numbers and that you haven't accidentally selected text-only cells.