Excel's AVERAGE function does the math for you

To find the average of a group of numbers in Excel, use the AVERAGE function. Type =AVERAGE(, then select the cells that contain your numbers, then type ) and press Enter. Excel adds all the numbers together and divides by how many numbers there are — that's your average.

The fastest way is to click the first cell with a number, hold Shift, and click the last cell. Excel highlights the whole range. Then you type the closing parenthesis and press Enter. The average appears in the cell where you typed the formula.

Key Takeaways

  • The AVERAGE function adds numbers and divides by the count automatically — you do not have to do the math yourself.
  • Select a range by clicking the first cell, holding Shift, and clicking the last cell, then Excel knows which numbers to include.
  • You can average cells that are not next to each other by typing their addresses separated by commas, like =AVERAGE(A1,A3,A5).
  • Excel ignores empty cells and text when calculating an average, so you do not have to clean up your data first.

Step-by-step: averaging a column of numbers

Open your spreadsheet and find the column with the numbers you want to average. Click on an empty cell below the numbers or to the right of them — this is where the average will appear.

Type =AVERAGE( without the quotes. Now click on the first cell that contains a number. You will see the cell address appear in your formula — for example, A1. Hold Shift and click on the last cell with a number in that column. Excel highlights all the cells between them and shows the range in your formula, like A1:A10.

Type the closing parenthesis ) and press Enter. Excel calculates the average and shows the result in your cell. If you click on that cell again, you will see the formula in the formula bar at the top.

Averaging numbers that are not in a row or column

Sometimes your numbers are scattered across the spreadsheet. You can still average them — you just have to type each cell address instead of selecting a range.

Click on an empty cell and type =AVERAGE(. Then type the first cell address, like A1. Type a comma, then type the next cell address, like C5. Keep typing commas and cell addresses for every number you want to include. When you are done, type ) and press Enter.

For example, if you want to average the numbers in cells A1, C3, and E7, you would type =AVERAGE(A1,C3,E7). This works even if those cells are in different columns or rows, or far apart from each other.

What AVERAGE ignores and why that matters

Excel's AVERAGE function skips over empty cells — it does not count them as zero. If you have a column with numbers in rows 1, 2, 4, and 5, but row 3 is blank, AVERAGE adds only the four numbers and divides by 4, not by 5.

AVERAGE also ignores cells that contain text. If one cell in your range has the word "pending" instead of a number, Excel leaves it out of the calculation. This means you do not have to delete text or empty cells before you average — Excel handles it automatically.

If every cell in your range is empty or contains only text, AVERAGE returns a #DIV/0! error. This tells you there are no numbers to average. Check that your range includes at least one cell with an actual number.

Using AVERAGE with conditions: AVERAGEIF

Sometimes you want to average only numbers that meet a certain condition. For example, you might want the average of sales only from January, or the average score only for students who passed. Use AVERAGEIF instead of AVERAGE.

Type =AVERAGEIF(, then select the range that contains the condition — for example, a column of months. Type a comma, then type the condition in quotes, like "January". Type another comma, then select the range with the numbers you want to average. Type ) and press Enter.

For example, if column A contains months and column B contains sales amounts, you would type =AVERAGEIF(A:A,"January",B:B) to get the average of all sales in January. AVERAGEIF only includes rows where the condition matches.

Common mistakes and how to fix them

The most common error is typing a cell address wrong. If you see #REF! in your cell, it means Excel cannot find the cell you named. Check that the letter and number match a real cell in your spreadsheet. If you typed A10 but meant A1, fix the number and press Enter again.

Another mistake is including a cell that contains text when you meant to include only numbers. AVERAGE skips the text automatically, but if you meant to average five numbers and one is text, your result will be lower than you expect. Look at every cell in your range and make sure it contains a number.

If your formula shows the formula itself instead of the result — like you see =AVERAGE(A1:A5) in the cell instead of a number — the cell is formatted as text. Right-click the cell, click Format Cells, and change the format to Number. Then press Enter and the formula will calculate.

Averaging across multiple columns or sheets

You can average numbers from different columns in the same sheet by typing multiple ranges separated by commas. For example, =AVERAGE(A1:A5,C1:C5) averages all numbers in both columns A and C.

To average numbers from a different sheet, type the sheet name followed by an exclamation point and the cell range. For example, if you have a sheet called "Sales" and you want to average cells A1 through A10 on that sheet, type =AVERAGE(Sales!A1:A10). The sheet name must match exactly, including capital letters.

Frequently Asked Questions

Does AVERAGE count zero as a number?

Yes. If a cell contains 0, AVERAGE includes it in the calculation. A zero is a number, not empty. If you want to exclude zeros, use AVERAGEIF with a condition like =AVERAGEIF(A:A,"<>0",A:A), which means "average all cells in column A that are not equal to zero".

What is the difference between AVERAGE and AVERAGEA?

AVERAGE counts only cells with numbers. AVERAGEA counts cells with numbers and treats text and empty cells as zero. In most cases, use AVERAGE. Use AVERAGEA only if you specifically want empty cells or text to count as zero in your calculation.

Can I average the results of other formulas?

Yes. If cells A1 through A5 each contain a formula, you can type =AVERAGE(A1:A5) and Excel will average the results of those formulas, not the formulas themselves. This works because AVERAGE looks at what the formula produces, not the formula code.

Why does my average seem wrong?

Check that you selected the right range. Click on the cell with the average, look at the formula bar, and verify the range matches the numbers you meant to include. Also check whether any cells contain text that looks like a number — AVERAGE ignores text, even if it looks like "100".

Can I average only the visible cells in a filtered list?

AVERAGE includes hidden cells. If you filter your data and want to average only the visible rows, use SUBTOTAL instead. Type =SUBTOTAL(1,A1:A10) — the 1 tells Excel to average only visible cells. This is useful when you have filtered out rows you do not want to include.