Home » Resources » Excel 2007 Tutorial » Calculating an Average

One of the simplest ways to get the average of a group of numbers or cells is to use the “AVERAGE” function.

This works the same way as the SUM function. For example, to calculate the average of cells C2 to C5 you woulsd type “=AVERAGE(C2:C5)” and then press enter:

You can also do this by using the AutoSum function we looked at earlier. In order to do this you first need to select a blank cell. Now, click on the downward arrow next to the AutoSum button in the ribbon. Select the “Average” option near the top of the list:

When you have done this you will see that =average() appears in the selected cell. All you need do now is to highlight with the mouse which cells you want to include in your equation.

Similar resources you may like

1. Highlighting Cells
2. Submitting Information
3. Auto Sum
4. Excel Functions
5. Reference Operators

Tags

average, calculating, Excel, Excel 2007 Tutorial, excel training, excel tutorial, Free, microsoft, microsoft excel, microsoft office, resource, Tips, top Tips, training

Share This Resource

This entry was posted by Alistair Wylie on Wednesday, May 6th, 2009 at 1:41 pm and is filed under Excel 2007 Tutorial. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.