Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Running totals in excel | New Users to Excel | |||
Pivot table and running total | Excel Discussion (Misc queries) | |||
Adding a Single Cell total from Seperate sheets | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Pivot Table - Running Total Annualised | Excel Discussion (Misc queries) |