Site Map

Using the sum function


Download and save the Excel file to your hard disk before working on it.

In this problem, your task is to calculate the Total of expenses for April, May, June and July.

You will need to use the SUM function .

Your answer will go in the cells shaded.

The SUM function can be typed or inserted automatically by the using the 'Autosum" button as circled in red on the toolbar below.

Click on the cell B20 and then click on the Autosum button on the standard toolbar. Then, using your mouse, select the range of cells to be totalled.

Excel will try to guess but does not always guess correctly the range of cells to be totalled.

You must hit Enter to finish and insert the Sum function.

You should see the formula: =SUM(B9:B19)

Watch the animation




Copyright Leo Isaac 2006 -2007

For permission to utilise materials please email webmaster