The AVERAGE function finds the mean of a group of numbers in Excel

To find the mean (average) of numbers in Excel, you use the AVERAGE function. Type =AVERAGE() into a cell, put the range of numbers you want to average inside the parentheses, and press Enter. Excel does the math and shows you the result. For example, if you have numbers in cells A1 through A10, you would type =AVERAGE(A1:A10).

The mean is the sum of all the numbers divided by how many numbers there are. Excel handles that division for you — you just tell it which cells to look at. This works whether your numbers are spread across a single row, a single column, or a rectangular block of cells.

Key Takeaways

  • The AVERAGE function syntax is =AVERAGE(range), where range is the cells containing your numbers.
  • You can average cells in a row (like A1:E1), a column (like A1:A10), or a block (like A1:C5).
  • If your data has empty cells or text, AVERAGE ignores them and only counts the numbers.
  • You can average multiple separate ranges by separating them with commas, like =AVERAGE(A1:A5,C1:C5).

Typing the AVERAGE formula into a cell

Click on the cell where you want the average to appear. Type the equals sign first — this tells Excel you are entering a formula, not just text. Then type AVERAGE followed by an opening parenthesis.

Next, select the range of cells you want to average. You can either type the range directly (like B2:B15) or click and drag to highlight the cells with your mouse. If you click and drag, Excel fills in the range for you. Close with a closing parenthesis and press Enter. The average appears in the cell.

Selecting a range of cells to average

A range is a group of cells in a line or block. The simplest ranges are a single row or column. To write a range, use the cell address of the first cell, a colon, and the cell address of the last cell. For example, A1:A10 means cells A1 through A10 in column A. B5:E5 means cells B5 through E5 in row 5.

You can also average a rectangular block. A1:C5 means all cells from A1 to C5 — that is, columns A, B, and C, rows 1 through 5. Excel counts every number in that block and divides by how many numbers it found.

What happens when your data has empty cells or text

The AVERAGE function ignores empty cells. If you have numbers in A1, A2, A4, and A5 but A3 is blank, AVERAGE still works correctly — it adds up the four numbers and divides by 4, not by 5. This is different from some other functions that treat blanks as zeros.

If a cell in your range contains text instead of a number, AVERAGE skips that cell too. This means you can safely use AVERAGE on a range that has a few text labels mixed in, and it will only average the actual numbers.

Averaging multiple separate ranges at once

Sometimes your numbers are not in one continuous block. You might have one group in column A and another group in column C, with column B containing labels. You can average both groups in a single formula by separating the ranges with commas.

Type =AVERAGE(A1:A10,C1:C10) to average cells A1 through A10 and also C1 through C10. Excel adds all 20 numbers together and divides by 20. You can add as many ranges as you need, separated by commas. This is faster than creating separate AVERAGE formulas for each range.

Copying the formula down to other rows

Once you have written the formula in one cell, you can copy it down to calculate the average for other groups of data. Click on the cell with your formula, then drag the small square in the bottom-right corner of the cell downward. Excel adjusts the cell references automatically — if your first formula was =AVERAGE(A1:A10), the next row becomes =AVERAGE(A2:A11), and so on.

This automatic adjustment is called a relative reference. If you want the formula to always point to the exact same cells no matter where you copy it, you would use absolute references by adding dollar signs, like =AVERAGE($A$1:$A$10). But for most situations, relative references are what you want.

When to use AVERAGE instead of other functions

AVERAGE finds the mean — the sum divided by the count. If you want the middle value instead (the median), use the MEDIAN function. If you want the most common value (the mode), use the MODE function. If you want the total of all numbers without dividing, use SUM.

For most everyday situations where someone asks for "the average," AVERAGE is the right choice. It is the most common way to describe a typical value in a set of numbers. Use it when you are calculating grade point averages, average sales per month, average temperature, or any other typical value.

Frequently Asked Questions

Can I average numbers that are in different sheets?

Yes. Type the sheet name followed by an exclamation point before the cell range. For example, =AVERAGE(Sheet1!A1:A10,Sheet2!A1:A10) averages cells from both sheets. If your sheet name has a space, put the name in single quotes: =AVERAGE('Sheet 1'!A1:A10).

What is the difference between AVERAGE and AVERAGEIF?

AVERAGE calculates the mean of all numbers in a range. AVERAGEIF calculates the mean of only the numbers that meet a condition you set. For example, =AVERAGEIF(A1:A10,">50") averages only the numbers greater than 50. Use AVERAGEIF when you want to exclude certain values.

Does AVERAGE include zero as a number?

Yes. If a cell contains 0, AVERAGE counts it as a number and includes it in the calculation. This is correct behavior — zero is a real value. If you want to exclude zeros, use AVERAGEIF with a condition like =AVERAGEIF(A1:A10,"<>0"), which means "not equal to zero."

Why does my AVERAGE formula show an error?

The most common cause is a typo in the formula or range. Check that you have the opening and closing parentheses, that the range uses a colon (not a dash), and that the cell addresses are correct. Another cause is selecting text-only cells with no numbers — AVERAGE cannot calculate a mean of pure text.