How do you link numerous cells in seperate worksheets to show a total figure in the last work sheet?

Thanks

Lucy

Hi Lucy

Almost the same way that you would in a single worksheet.

Start by typing your formula type e.g. =SUM(

Then move to the worksheet you want and select the cell you want

You then need to insert either a comma or a plus sign to stop the selected cell changing when you move worksheets, but once you've done that just keep repeating the last two steps until you've selecteed all the cells you want, then hit return.

Hope that helps

Tristan

Or to link using a 'cookie cutter' formula is a quick when you have many many sheets and it is always the same cell ref that you want:

Type:

=SUM('firstpagename:lastpagename'!A1:A1)

BUT beware, if you drag a sheet into or out of this range it will add/drop a cell. Warn yourself with something visual by having a blank first and last sheet that you name FIRST and LAST as you'd have to drag a sheet over that one to enter/exit the range.