Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add (=Sum) the same cell for multiple sheets (103)
How do I add (=Sum) the same cell for multiple sheets (103). I don't want to
use the +sum(sheet1,sheet2,etc) 103 times. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add (=Sum) the same cell for multiple sheets (103)
If it is all sheets =SUM(Sheet1:Sheet3!G1) would work if for example sheet1 is the first sheet and sheet3 the last sheet Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=535542 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add (=Sum) the same cell for multiple sheets (103)
=SUM(Sheet1:Sheet103!C34) entered on Sheet104
Even better is to insert a new dummy sheet at left and a new dummy sheet at right-end of other sheets. Name them Start and End Formula =SUM(Start:End!C34) Any new sheets can be inserted between these two dummy sheets. Now it doesn't matter what the intervening sheets are named. Gord Dibben MS Excel MVP On Mon, 24 Apr 2006 07:41:02 -0700, How do I sum sheets <How do I sum wrote: How do I add (=Sum) the same cell for multiple sheets (103). I don't want to use the +sum(sheet1,sheet2,etc) 103 times. Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming sheets from a cell value | Excel Discussion (Misc queries) | |||
Changed referenced cell between sheets | Excel Discussion (Misc queries) | |||
How to have a variable cell reference across sheets? | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions |