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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shawn - 21 Dec 2005 01:36 GMT

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

Reply to this Message

paul - 21 Dec 2005 08:49 GMT

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()

Signature

paul
remove nospam for email addy!

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

Reply to this Message

Allewyn - 21 Dec 2005 20:37 GMT

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.

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

Reply to this Message

Gord Dibben - 21 Dec 2005 20:37 GMT

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

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

Reply to this Message