Now that the data has been entered into the spreadsheet, we can enter a formula into cell F3 to calculate the total number of tracksuits Sam hopes to sell in the first four months.

The formula is '=B3+C3+D3+E3' and when the Enter key is pressed the result 50 is shown.
We could have used the alternative formula '=SUM (B3:E3)'.

© Microsoft Corporation

The same can be done for trainers and accessories by selecting cell F3, copying it and then selecting cells F4 and F5, and pasting into them (Copy and Paste are found under Edit in the menu bar). The formulas for the new cells are adjusted automatically so the formula for cell 'F4' would become '=B4+C4+D4+E4' and the same would apply to cell 'F5.'

© Microsoft Corporation