The simplest way to find an average in Excel

To find the average of a group of numbers in Excel, type =AVERAGE() into an empty cell, put the range of cells you want to average inside the parentheses, and press Enter. For example, if your numbers are in cells A1 through A10, you would type =AVERAGE(A1:A10) and the average appears in that cell.

Excel does the math for you — it adds all the numbers and divides by how many numbers there are. You do not have to calculate it yourself or count the cells. The formula works the same way whether you have 5 numbers or 500.

The colon between A1 and A10 tells Excel to include every cell in that range. If your numbers are not in a continuous block, you can list them separately by using commas instead: =AVERAGE(A1, A3, A5) would average only those three cells, skipping A2 and A4.

Key Takeaways

  • Type =AVERAGE() with your cell range inside the parentheses to get the average of any group of numbers.
  • Use a colon to include a continuous range (A1:A10) or commas to pick specific cells that are not next to each other (A1, A3, A5).
  • Excel calculates the average automatically — you do not have to count cells or do the division yourself.
  • You can combine AVERAGE with other formulas or use it on numbers in different sheets, columns, or rows.

Selecting the cells you want to average

Before you type the formula, decide which cells hold the numbers you want to average. Click on the first cell, then hold Shift and click on the last cell to select the whole range at once. Excel highlights the selected cells in blue.

If your numbers are scattered across the sheet instead of in one block, hold Ctrl (or Cmd on a Mac) and click each cell individually. The cell references appear in your formula separated by commas. This method takes longer but works when your data is not organized in rows or columns.

You can also type the range directly into the formula without selecting first — just make sure you use the correct cell letters and numbers. If you are not sure which cells to include, select them first and watch Excel show you the range in the formula bar at the top of the screen.

Averaging numbers in different columns or rows

The AVERAGE formula works the same way no matter how your numbers are arranged. If your data runs down a column (A1, A2, A3, and so on), use =AVERAGE(A1:A10). If your data runs across a row (A1, B1, C1, and so on), use =AVERAGE(A1:C1).

You can also average numbers from multiple columns or rows at once. For example, =AVERAGE(A1:A10, C1:C10) averages all the numbers in column A from rows 1 to 10, plus all the numbers in column C from rows 1 to 10. Excel treats this as one calculation and gives you a single average.

If you need to average numbers from different sheets in the same workbook, include the sheet name before the cell range: =AVERAGE(Sheet2!A1:A10). The exclamation mark tells Excel to look in a different sheet. This is useful when your data is split across multiple tabs.

What happens when cells are empty or contain text

Excel ignores empty cells when calculating an average. If you have numbers in A1, A2, A4, and A5 but A3 is blank, AVERAGE still works correctly — it adds the four numbers and divides by 4, not by 5. This is different from some other programs that might count the empty cell as zero.

If a cell contains text instead of a number, Excel skips it too. This means you can safely use AVERAGE on a range that includes labels or notes without breaking the formula. For example, if A1 says "Sales" and A2 through A10 contain numbers, =AVERAGE(A1:A10) averages only the nine cells with numbers.

If every cell in your range is empty or contains only text, the formula returns an error message that says #DIV/0!. This means Excel has nothing to average. Check that your range includes at least one number, and that the numbers are actually stored as numbers and not as text that looks like numbers.

Using AVERAGE with conditions

Sometimes you want to average only numbers that meet a certain condition — for example, only sales above $1,000 or only test scores from a particular month. For this, use =AVERAGEIF() instead of AVERAGE.

The AVERAGEIF formula takes three parts: the range to check, the condition, and the range to average. For example, =AVERAGEIF(B1:B10, ">1000", C1:C10) looks at cells B1 through B10, finds only the ones greater than 1000, and then averages the matching numbers in C1 through C10. You can use conditions like ">", "<", "=", or even text like "red" or "pending".

If you need multiple conditions — for example, sales above $1,000 AND in the month of March — use =AVERAGEIFS() instead. This formula lets you add as many conditions as you need, separated by commas. The syntax is slightly different, so check Excel's help if you need to use it.

Placing your average formula in the right cell

Click on an empty cell where you want the average to appear. This is usually below or to the right of your data, so it is straightforward to see. Type your formula and press Enter. The average appears in that cell, and the formula stays hidden in the background — you only see the result.

If you want to see the formula again later, click on the cell with the average and look at the formula bar at the top of the screen. It shows the formula you typed. You can edit it there if you need to change which cells you are averaging.

You can copy the formula to other cells if you need to calculate multiple averages. Click the cell with your formula, press Ctrl+C (or Cmd+C on a Mac), then select the cells where you want the formula to go and press Ctrl+V. Excel automatically adjusts the cell references for each row or column, so each formula averages the correct range.

Common mistakes when using AVERAGE

The most common error is forgetting the colon between the first and last cell. =AVERAGE(A1 A10) does not work — you need =AVERAGE(A1:A10). Excel shows an error if you forget it.

Another mistake is including the wrong cells by accident. Double-check that your range starts and ends where you think it does. If you have a header row with a label like "Sales", make sure you start your range at the first number, not at the label. For example, use =AVERAGE(A2:A10) if "Sales" is in A1.

Some people accidentally type the formula as text instead of as a formula. This happens if you start with a space or a single quote instead of an equals sign. Always start with = to tell Excel you are entering a formula, not text.

Frequently Asked Questions

Can I average numbers that are in different sheets?

Yes. Include the sheet name in your formula with an exclamation mark: =AVERAGE(Sheet1!A1:A10, Sheet2!A1:A10). This averages the ranges from both sheets as one calculation. Make sure you spell the sheet name exactly as it appears on the tab.

What is the difference between AVERAGE and AVERAGEIF?

AVERAGE includes all numbers in the range you specify. AVERAGEIF lets you set a condition — for example, average only numbers greater than 100 or only cells that say "yes". Use AVERAGE for a straightforward average of all numbers, and AVERAGEIF when you need to filter first.

Why does my AVERAGE formula show an error?

The most common reasons are: you forgot the equals sign at the start, you used a space instead of a colon between cell references, or your range contains no numbers at all. Check that your formula starts with =, uses colons correctly, and includes at least one cell with a number in it.

Can I average numbers and ignore zeros?

AVERAGE includes zeros in the calculation. If you want to ignore zeros, use =AVERAGEIF(A1:A10, "<>0"). The "<>" means "not equal to", so this averages only cells that are not zero. This is useful when zeros represent missing data rather than actual values.

Does AVERAGE work with negative numbers?

Yes. AVERAGE treats negative numbers the same as positive numbers — it adds them all up and divides by how many there are. If you have both positive and negative numbers, the average reflects both.