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. |
How do I add totals up from different sheets? A running total.
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. |
How do I add totals up from different sheets? A running total.
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!M 1+'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. |
How do I add totals up from different sheets? A running total.
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" wrote: How do I add totals up from different sheets? A running total of all the totals on each worksheet? thanks. |
All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com