How to Calculate Average in Excel 2010

You may have used formulas in Excel 2010 to find things like the sum of a range of cells, but Excel is capable of some other mathematical operations as well.

For example, it can find the average of a range of cells using a formula found within the program.

This can be a time saver if you had previously been finding your averages manually or if you had been using two formulas to find the answer that you required.

The steps in this article will show you how to use the average function in Excel 2010.

Averages in Excel work in a very similar way to other formulas that you might have used, such as the SUM formula that can add together values in multiple cells.

How to Find an Average in Excel 2010

We are going to find the average of a column of 10 numbers, and we are going to enter the formula manually.

While you can also insert the formula from the More Functions -> Statistical menu on the Formulas tab, I find that it is more helpful to learn the formula by typing it out yourself a few times. You can, however, see in the image below where the average function is located –

where to find the average formula on the formulas tab

With that in mind, follow the steps below to learn how to get the average of a group of cells in Excel 2010.

Step 1: Open the spreadsheet containing the cells for which you want to find an average.

Step 2: Click inside the cell in which you want the average to be displayed.

select the cell into which to enter the average formula

Step 3: Type =AVERAGE( XX:YY) into the cell. Replace XX with the first cell in your range, and YY with the last cell in your range, then press Enter on your keyboard. For example, in the image below I am finding the average of cells B2 -> B11.

enter the average formula into the cell

The average will then be displayed in the cell in which you entered the formula.

view the average

If you want to change or adjust the cells in the formula, you can click on the cell with the average, then edit the formula in the formula bar at the top of the window.

how to calculate average in Excel 2010

You are also not restricted to finding the average of a range of cells. You can specify individual cells by editing the formula so that it looks like =AVERAGE(XX, YY, ZZ). Note the space after each comma in the series.

other options for using the average formula in excel 2010

Summary – How to use the average function in Excel 2010

  1. Click inside the cell where you want to display the average.
  2. Type =AVERAGE(XX:YY) into this cell, but replace XX with the first cell in the range, then replace YY with the last cell in the range.
  3. Press Enter on your keyboard to calculate the formula.

Now that you know how to calculate average in Excel 2010, you can use this formula to help you make these calculations in your spreadsheets.

Looking for another helpful formula? Try out CONCATENATE if you want to combine the values from multiple cells into one cell. Read this article to learn more.