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

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

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()
--
paul
remove nospam for email addy!



"Shawn" wrote:

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

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.

"Shawn" wrote:

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

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


On Tue, 20 Dec 2005 17:36:03 -0800, "Shawn" <Shawn@discussions.microsoft.com>
wrote:

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