Microsoft Excel 
ITTraining@sgul.ac.uk Page 28 St. George’s Information Services 
CALCULATING AN AVERAGE 
 
 
 
 
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
The AVERAGE function allows you to average 
the values in a range of cells. It is written in much 
the same way as the SUM function, for example, 
=AVERAGE(range of cells to average). The 
average function can be applied using the 
Functions Wizard, a part of Excel that steps you 
through the process of creating a function or you 
can type it in yourself if you are comfortable with it. 
 
Try This Yourself: 
Same 
File Continue using the previous file 
with this exercise, or open the 
file E710 Formulas_6.xlsx... 
 
Click on B29 then click on the 
Insert Function
 tool  to 
display the Insert Function 
dialog box 
 
Click on AVERAGE in Select a 
function then click on [OK] to 
display the Function 
Arguments dialog box 
 
Click on the Range Selector 
tool  for Number1 to roll up 
the wizard, then hold down  
and select the following ranges 
B6:B8 
B11:B13 
B16:B18 
B21:B23 
 
Press  to complete the 
range specifications, then click 
on [OK] to complete the process 
Let’s use the AutoSum 
function… 
 
Click on B34, then click on the 
drop arrow for the Sum 
command  on the Editing 
group, then select Average 
 
Click on B9
, hold down  and 
click on B14, B19 and B24, then 
press  to complete the 
formula 
 
For Your Reference… 
To insert an average function: 
1. Click in the cell then click on the Insert 
Function
 tool   
2. Click on AVERAGE in Select a function  
3. Insert the required ranges then click on 
[OK] 
Handy to Know… 
 You can type queries like “How do I work out 
the monthly payment for a car loan?” into the 
Search box in the Insert Function dialog 
box. Once you have selected a function from 
the Select a function list, the Function 
Arguments dialog box will help you to enter 
the values into the function. 
  
3 
1 
5