How do I add totals up from different sheets? A running total.

S

Shawn

How do I add totals up from different sheets? A running total of all the
totals on each worksheet?
thanks.
 
P

paul

in the cell you want the total type= and thenand begin clicking on the cells
across the sheets you want to sum with a+ between or Sum()
 
A

Allewyn

It will look something like this, when using separate sheets

=SUM(List!R1+Priors!S1+'Builders A & B'!Q1+'Builders C & D'!B2+'Builders E &
F'!O1+'Builders G & H'!P2+'Builders I & J'!P1+'Builders K &
L'!P1+Wealthy!W1+'SmBus -
97537'!Q2+SmBus97501!T2+Downtown!M1+DNC!C1+Later!M1+'List 2'!Q1)
This gives totals from 15 different sheets on a separate summary sheet I'm
using.
 
G

Gord Dibben

Shawn

If the total cell on each sheet is same cell you can use

=SUM(Sheet1:Sheet23!cellref)

To allow for inserting more sheets later, I recommend inserting a dummy sheet
named Start at first sheet in book.

Insert a dummy sheet named End at last sheet in book.

Then formula can be =SUM(Start:End!cellref)

New sheets will be inserted between Start and End sheets.


Gord Dibben Excel MVP
 
Top