The AVERAGE function calculates the mean of your numbers in one step

Excel's AVERAGE function adds up a group of numbers and divides by how many numbers there are — the mathematical definition of an average. Instead of adding cells by hand and counting them, you type a formula that does both at once. The formula looks like this: =AVERAGE(A1:A10), where A1:A10 means "all cells from A1 through A10".

The function ignores empty cells and text, so if you have a column with some blank rows or labels mixed in, AVERAGE skips them automatically. It also ignores cells containing the word "TRUE" or "FALSE" unless you force it to count them — which almost nobody needs to do.

You can average as few as two numbers or as many as your spreadsheet holds. You can also average cells that are not next to each other by separating them with commas: =AVERAGE(A1, A5, A10) averages only those three cells, skipping everything in between.

Key Takeaways

  • Type =AVERAGE(A1:A10) in any cell to find the average of cells A1 through A10, and Excel calculates it when ready.
  • The colon (:) means "through" — so A1:A10 includes all ten cells in that range.
  • Empty cells and text are ignored, so you do not have to clean up your data first.
  • Use commas to average cells that are not next to each other: =AVERAGE(A1, C5, E9).

Where to type the formula and what happens next

Click on any empty cell where you want the average to appear. Type the formula starting with an equals sign: =AVERAGE(A1:A10). Then press Enter. Excel calculates the result and shows it in that cell.

The formula stays in the cell even after you press Enter. If you click on the cell again, you will see the formula in the formula bar at the top of the screen, and the cell itself shows the number. If any of the numbers in your range change, the average updates automatically.

You can copy the formula to other cells. If you copy =AVERAGE(A1:A10) down to the next row, Excel automatically adjusts it to =AVERAGE(A2:A11) — it shifts the range down by one row. This is useful when you have multiple columns of data and want to average each one.

Selecting the range by clicking and dragging

You do not have to type the cell addresses. Start typing =AVERAGE(, then click on the first cell you want to include. Hold down the mouse button and drag to the last cell. Excel highlights the range in blue and fills in the addresses for you. Then type the closing parenthesis and press Enter.

This method is faster and less error-prone than typing addresses by hand, especially when you are averaging a long column. It also helps you see exactly which cells are included before you commit to the formula.

Averaging only cells that meet a condition

Sometimes you want the average of only certain numbers — for example, sales over $500, or test scores above 70. The AVERAGEIF function does this. The formula looks like: =AVERAGEIF(A1:A10,">500"), which averages only the numbers in A1:A10 that are greater than 500.

You can use any comparison: greater than (>), less than (<), equal to (=), not equal to (<>), greater than or equal to (>=), or less than or equal to (<=). Put the comparison in quotes, like ">500" or "<70".

If your data is in one column and your condition is in another, use AVERAGEIFS (plural). For example, =AVERAGEIFS(B1:B10, A1:A10, "North") averages the numbers in column B only where column A says "North". You can add multiple conditions by adding more pairs of columns and criteria.

Common mistakes and how to fix them

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

Another mistake is using the wrong bracket type. Excel formulas use parentheses ( ), not square brackets [ ] or curly braces { }. If you see an error message, check that you have the right brackets.

If your range includes text that looks like numbers — for example, a column where some cells say "N/A" or "pending" — AVERAGE ignores those cells, which is usually what you want. But if you need to count them as zero, you will need a different approach, like using SUMPRODUCT or converting the text to actual numbers first.

When to use AVERAGE instead of other functions

Use AVERAGE when you want the middle value mathematically — the sum divided by the count. Use MEDIAN when you want the middle value by position (useful if you have outliers that skew the average). Use MODE when you want the number that appears most often.

If you want to see the sum without dividing, use SUM. If you want to count how many numbers are in your range, use COUNT. These functions work the same way as AVERAGE — you type the range in parentheses and press Enter.

For most everyday tasks — calculating a class average, a monthly average, or an average price — AVERAGE is the right choice. It is fast, automatic, and updates when your data changes.

Frequently Asked Questions

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 a space, put it in single quotes: =AVERAGE('Sheet 2'!A1:A10). Excel adds the sheet reference automatically if you click on cells in a different sheet while building the formula.

What if some of my numbers are negative?

AVERAGE treats negative numbers normally — they pull the average down, just as they should mathematically. If you want the average of the absolute values (ignoring the negative sign), use =AVERAGE(ABS(A1:A10)), but this requires pressing Ctrl+Shift+Enter instead of just Enter to work as an array formula.

Does AVERAGE round the result?

No, AVERAGE shows the full decimal result. If you want to round it to a whole number or a certain number of decimal places, wrap it in the ROUND function: =ROUND(AVERAGE(A1:A10),0) rounds to the nearest whole number, and =ROUND(AVERAGE(A1:A10),2) rounds to two decimal places.

Can I average a column that has some empty cells?

Yes. AVERAGE automatically skips empty cells and only counts the cells with numbers. So =AVERAGE(A1:A100) will average only the cells in that range that actually contain numbers, no matter how many blanks are mixed in.