The+SUM+Function

Although you can simply use the addition sign (i.e. [=A1+B1]) to add the values of two cells together, sometimes you may need to add more than two cells together. Once again, the addition sign will work, but a much quicker way is to use the SUM function.

How it works:

Say you need to add up the totals of cells B9 to B12. All you need to do is...

1. Highlight the desired cell in which you want the total to be present.

2. Within that cell, or in the function box, type: =SUM(B9:B12).

3. Press enter and the desired total should pop up in the highlighted box.

The colon between A1 and A26 will denote that you intend to include all cells between B9 and B12.

It is as simple as that!!