The AVERAGE function does the math for you

To calculate an average in Excel, type =AVERAGE( followed by the cells you want to average, then close with ). For example, if your numbers are in cells A1 through A10, you would type =AVERAGE(A1:A10) and press Enter. Excel adds all the numbers and divides by how many numbers there are — you do not have to do the division yourself.

The colon between A1 and A10 tells Excel to include every cell in that range. If your numbers are scattered across different cells that are not next to each other, you can list them separately with commas instead: =AVERAGE(A1,A3,A7) will average only those three cells and skip A2 and A4.

You can also type the numbers directly into the formula if you only have a few: =AVERAGE(10,20,30) gives you 20. But if you have more than a handful of numbers, selecting a range is faster and less error-prone.

Key Takeaways

  • The AVERAGE function adds all your numbers and divides by how many numbers there are, so you do not have to calculate it by hand.
  • Use a colon between two cell names to average a range: =AVERAGE(A1:A10) averages cells A1 through A10.
  • Use commas to average cells that are not next to each other: =AVERAGE(A1,A3,A7) averages only those three cells.
  • The formula works the same way whether your numbers are whole numbers, decimals, or negative numbers.
  • You can copy the formula down to calculate averages for multiple rows or columns at once.

Where to put the formula

Click on the cell where you want the average to appear. This is usually below or to the right of your numbers, in a spot where the result will be straightforward to see. Then type your formula and press Enter.

Excel will calculate the average and show the result in that cell. The formula itself stays hidden — you only see the number. If you click on the cell again, the formula bar at the top of the screen shows you what formula is actually in there, so you can check it or edit it.

Averaging a column or row of data

If your data runs down a column, select the range from the first number to the last. Click on the first cell, hold Shift, and click on the last cell. Then type =AVERAGE( and Excel will automatically fill in the range you selected. You can also type the range by hand if you know the cell names.

For a row of numbers running left to right, the process is the same — select from the first cell to the last, then type the formula. Excel does not care whether your data is in a column or a row; the AVERAGE function works either way.

If you have a large spreadsheet with many columns of data, you can type the formula once and copy it across or down to calculate the average for each column or row. Click on the cell with the formula, copy it (Ctrl+C on Windows, Command+C on Mac), then select the cells where you want the formula to go and paste (Ctrl+V or Command+V). Excel will adjust the cell references automatically.

When AVERAGE includes cells you do not want

The AVERAGE function counts empty cells as zero only if they are truly empty. If a cell contains text, a space, or a formula that returns nothing, AVERAGE usually ignores it. But if you have a cell with the number 0 in it, AVERAGE will include that 0 in the calculation.

If you want to average only cells that meet a certain condition — for example, only numbers greater than 10, or only cells in a certain month — use AVERAGEIF instead. The formula looks like =AVERAGEIF(A1:A10,">10") to average only numbers larger than 10 in the range A1 to A10.

For more complex conditions, such as averaging numbers that are both greater than 10 and less than 50, use AVERAGEIFS. The formula would be =AVERAGEIFS(A1:A10,A1:A10,">10",A1:A10,"<50"). These variations are less common but useful when your data has conditions attached.

Checking your result makes sense

After you calculate an average, glance at your original numbers to make sure the result is reasonable. The average should fall somewhere between your smallest and largest number. If it does not, you may have included a cell you did not mean to, or typed the range wrong.

A common mistake is selecting one cell too many or too few. If your numbers are in A1 through A10 but you typed =AVERAGE(A1:A11), you have included an empty cell or a cell with text, which can throw off the result. Check the formula bar to see exactly which cells you included.

Frequently Asked Questions

Does AVERAGE include zero?

Yes. If a cell contains the number 0, AVERAGE includes it in the calculation. If you want to exclude zeros, use =AVERAGEIF(A1:A10,"<>0"), which averages only cells that are not equal to zero.

What if I have text mixed in with my numbers?

AVERAGE ignores text cells and only averages the numbers. If you have a cell that says "Total" or "N/A" in your range, Excel skips it and averages only the numeric values.

Can I average cells from different sheets?

Yes. Type the sheet name followed by an exclamation point and the cell range: =AVERAGE(Sheet2!A1:A10). If your sheet name has a space in it, put the name in single quotes: =AVERAGE('Sheet 2'!A1:A10).

What is the difference between AVERAGE and MEDIAN?

AVERAGE adds all numbers and divides by how many there are. MEDIAN finds the middle number when all numbers are sorted from smallest to largest. Use MEDIAN when you have outliers — very large or very small numbers that skew the average.

How do I average only the visible cells in a filtered list?

Use SUBTOTAL instead of AVERAGE. Type =SUBTOTAL(1,A1:A10) to average only the cells you can see after filtering. The number 1 tells SUBTOTAL to calculate an average; other numbers calculate sum, count, and other functions.