excel training course - HOW DO I CREATE A FORMULA

Hi Tanis,

Thanks for the question.

The sum function is the easiest way to total numbers up within a range. You can use the Autosum button on the toolbar or similarly you can type =sum( and then highlight the range of cells you want to add up.

If you use a comma instead of a colon you can add individual cells up. For example, =sum(A1:C1) will add up A1 plus B1 plus C1, wheras =sum(A1,B1) will only add up the two cells A1 and B1.

Is there any specific questions or problems you have? If so please do not hesitate to let me know

Tracy