excel advanced training - Sum through worksheets

Hi Dawn:

You can use the SUM() function, but instead of summing a range of cells on the same sheet, you sum the same cell on a range of sheets. The formula is of the form:

=SUM('Sheet1:Sheet6'!A1)

To avoid typing, you can use the mouse to build up the formula as follows:

1. Select the cell where you want the result to be.
2. Click the AutoSum button, or type =SUM(
3. Click the TAB of the first sheet to be included in the sum.
4. Hold down SHIFT and click the TAB of the final sheet to be included. (The sheet tabs will turn white)
5. Release SHIFT and select the CELL to be summed.
6. Press ENTER before clicking back on the sheet you started from.


Once the correct formula is in one cell it can be copied to adjacent cells with Autofill.

Regards,

Tony Gay