training microsoft excel - Sum

Hi Joanne

Thanks for your question.

If you enter a formula where you want the total to appear, that adds the cells you are entering the numbers into, then the total will change as the numbers are entered into the spreadsheet.

Example: if the formula is entered into cell A15 as =sum(A1:A14), the total of the numbers entered into cells A1 to A14 will appear in cell A15.

Amanda