Sum (15 minutes)

To find the sum (total) of a column of figures there are two popular ways to do this. The easiest is to select the column of figures and include a blank cell where you want the answer to appear and then click the AutoSum button. The second way is to construct the Sum formula in the cell where the answer should appear. For example type =SUM(A2:A10).

Watch the video, ‘AutoSum’, to see how to do this and then add up all the columns in your worksheet. Your answers should appear in the pink cells entitled ‘Total’ at the foot of each column.