Sum through sheets

In our workbook we have thirteen sheets. The first is a Totals sheet and this is followed by twelve sheets labelled Jan through to Dec (Jan is the first sheet and Dec is the last). C10 of each month's worksheet contains the sales figure that we wish to consolidate on the Totals sheet.

The usual approach would be to type the formula: =Jan!C10+Feb!C10+Mar!C10+Apr!C10... but there is a quicker solution.

Follow these steps:

(1) In the Totals sheet, type =SUM( to begin to create the formula.

(2) Select C10 on the Jan sheet.

(3) Hold down Shift and select the Dec sheet.

(4) Type ).

(5) Press Enter to complete the formula.

The resulting formula is =SUM(Jan:Dec!C10) which sums C10 through the sheets Jan to Dec.

It is important to realise that the formula works because the sales figure is in C10 on every sheet