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 hold the numbers you want to average. Excel then calculates the result and shows it in the cell where you typed the formula.

The basic formula looks like this: =AVERAGE(A1:A10). This tells Excel to average the numbers in cells A1 through A10. You can change the cell references to match wherever your numbers actually are.

This matters because averaging by hand is slow and error-prone, especially with dozens or hundreds of numbers. A formula does it when ready and recalculates automatically if you change any of the numbers it's averaging.

Key Takeaways

  • Type =AVERAGE(A1:A10) into any cell to average the numbers in cells A1 through A10; change the letters and numbers to match your data.
  • A colon between two cell references (like A1:A10) means "all cells from A1 to A10"; a comma between references (like A1,A5,A10) means "only these specific cells".
  • If you change any number in the range the formula is averaging, the average updates automatically without you retyping anything.
  • Excel ignores empty cells and text when calculating an average, so you don't need to clean up your data first.

How to set up a basic average formula

Open your spreadsheet and click on the cell where you want the average to appear. This is usually below or to the right of the numbers you're averaging, so it's straightforward to see which calculation goes with which data.

Type the equals sign first — this tells Excel you're entering a formula, not just text. Then type AVERAGE, an opening parenthesis, the first cell reference, a colon, the last cell reference, and a closing parenthesis. For example, if your numbers are in column B from row 2 to row 11, type =AVERAGE(B2:B11).

Press Enter. Excel calculates the average and displays the result in that cell. The formula bar at the top of the screen shows the formula itself, so you can see what calculation is happening.

Averaging non-consecutive cells or specific rows

Sometimes your numbers aren't in one continuous block. You might have data in cells A2, A5, and A9, but nothing in between. Use commas instead of a colon to tell Excel which specific cells to average.

Type =AVERAGE(A2,A5,A9) to average only those three cells. You can mix this approach with ranges too: =AVERAGE(A2:A4,A9,B2:B5) averages cells A2 through A4, then cell A9, then cells B2 through B5 — all in one formula.

This is useful when you have headers or labels in some rows, or when you want to exclude certain data without deleting it. The formula only touches the cells you name.

What happens when your data includes empty cells or text

Excel's AVERAGE function automatically skips empty cells. If you have numbers in A1, A2, A4, and A5 but A3 is blank, the formula =AVERAGE(A1:A5) will average only the four numbers that exist, not treat the blank as a zero.

Text in a cell is also ignored. If one cell contains the word "Total" or a date formatted as text, AVERAGE skips it and averages only the actual numbers. This means you don't have to clean up your spreadsheet before using AVERAGE — the function handles mixed data gracefully.

The one exception: if every cell in your range is empty or contains only text, the formula returns an error. This rarely happens in practice, but if you see #DIV/0! or #VALUE!, it usually means you've pointed the formula at the wrong range.

Copying a formula down to multiple rows

If you have multiple groups of numbers and need to average each group separately, you don't have to retype the formula each time. Click the cell with your formula, then drag the small square in the bottom-right corner of that cell downward. Excel copies the formula to each new row and automatically adjusts the cell references.

For example, if you type =AVERAGE(A1:A5) in cell C1 and drag down to C3, Excel creates =AVERAGE(A1:A5) in C1, =AVERAGE(A6:A10) in C2, and =AVERAGE(A11:A15) in C3. Each formula shifts down by the same number of rows you dragged.

This saves time and reduces mistakes. You set up the logic once, and Excel handles the repetition.

Using AVERAGE with conditions (AVERAGEIF)

Sometimes you want to average only numbers that meet a certain condition. For instance, you might have a list of sales by region and want to average only the sales from the North region. The AVERAGEIF function does this.

The formula looks like this: =AVERAGEIF(B2:B10,"North",C2:C10). This tells Excel to look at cells B2 through B10, find all the ones that say "North", and average the corresponding numbers in C2 through C10. The condition goes in quotes if it's text, or without quotes if it's a number or comparison like ">100".

AVERAGEIF is more complex than basic AVERAGE, but it's worth learning if you work with data that needs to be filtered before averaging. It's faster and more reliable than manually selecting which rows to include.

Common mistakes and how to fix them

Forgetting the equals sign is the most common error. If you type AVERAGE(A1:A10) without the = at the start, Excel treats it as text and displays the formula itself rather than calculating it. Always start with =.

Mismatched parentheses also cause errors. Every opening parenthesis needs a closing one. If you type =AVERAGE(A1:A10, Excel will show an error because the formula is incomplete. The formula bar helps here — it highlights matching parentheses as you type, so you can spot the problem.

Pointing at the wrong range is another frequent issue. Double-check that A1:A10 actually contains the numbers you want to average. Click on the cell with the formula and look at the formula bar to see exactly which cells it's referencing. If the range is wrong, click in the formula bar, edit the cell references, and press Enter.

Frequently Asked Questions

Can I average numbers in different columns at the same time?

Yes. Use =AVERAGE(A1:A10,C1:C10) to average all numbers in both column A and column C. You can include as many ranges or individual cells as you need, separated by commas. Excel adds them all together and divides by the total count of numbers.

What's the difference between AVERAGE and AVERAGEA?

AVERAGE ignores text and empty cells. AVERAGEA counts empty cells as zero and tries to convert text to numbers (usually failing). For most work, AVERAGE is what you want. Use AVERAGEA only if you specifically need empty cells treated as zero.

Does AVERAGE work with negative numbers?

Yes. Negative numbers are treated like any other number. If you average 10, -5, and 15, the result is 6.67. The formula doesn't care whether the numbers are positive or negative.

How do I average only numbers above or below a certain value?

Use AVERAGEIF with a comparison operator. For example, =AVERAGEIF(A1:A10,">50") averages only numbers greater than 50 in the range A1:A10. You can use >, <, >=, <=, or = to set the condition.

What if I want to average the results of other formulas?

AVERAGE works on the results of other formulas just as it works on plain numbers. If cells A1 through A10 each contain a formula, =AVERAGE(A1:A10) averages the calculated results. Excel handles this automatically — you don't need to do anything different.