How to Average a Group of Cells in Excel 2010

Microsoft Excel 2010 has a lot of tools that you can use to easily accomplish tasks that Excel users commonly perform.

While many of these tools are geared toward editing data and changing the layout and appearance of your spreadsheets, Excel 2010 can also use a number of formulas and utilities to compare and summarize groups of data.

One way that this is possible is through the AutoSum feature. While the primary use of this tool is simply adding a group of selected cells, it also has some pretty helpful sub tools.

One of these items will allow you to average a group of cells in Excel 2010 by adding the total of the values in each cell, then dividing by the number of selected cells.

Finding An Average of Cells in Excel 2010

There are a lot of ways to simplify common tasks in Excel. Using the method described below, you will learn how to average a group of cells in Excel 2010, which will result in the average value being displayed in the empty cell below your highlighted values.

Step 1: Open the Excel file containing the cells whose values you wish to average.

Step 2: Use your mouse to select all of the cells that will be part of your calculation.

select the cells to average in excel 2010

Step 3: Click the Home tab at the top of the window, if it is not already selected.

excel 2010 home tab

Step 4: Click the AutoSum drop-down menu in the Editing section of the ribbon at the top of the window, then click the Average option.

how to average a group of cells in excel 2010

Step 5: The average of all of your cells will be displayed in the first empty cell below or to the right of your selected cells.

check the average in excel 2010

Now that you know how to average a group of cells in Excel 2010, you can quickly determine this information for a group of cells in your spreadsheet.

if you click the cell containing the average, you will note that the value displaying your average is actually a formula of the structure =AVERAGE(AA:BB), where AA is the first cell in the series, and BB is the last cell in the series. If you change the value of any of the cells in your selection, the average will automatically update to reflect that change.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Leave a Comment