Can I show totals from sheets 2 &.3 on sheet 1

C

Chezney

I have information on sheets 1, 2, 3,4 etc. Can I collate the totals from
each sheet on a master speread sheet 1?c
 
P

Pete_UK

Suppose your totals are in cell D2 on each of those sheets, and that
the summary sheet is positioned either before Sheet1 or after your
last sheet (i.e. not in the middle of the first and last sheets). Then
you can use this formula to add them all up:

=SUM(Sheet1:Sheetn!D2)

where Sheetn is your last sheet in the sequence.

Hope this helps.

Pete
 
Top