Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
Need to sum same cell on numerous worksheets w/i a workbook
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
I like this technique...
Create two new worksheets--one to the far right and one to the far left. Call them Start and End Then using a sheet (Summary) that is outside this "sandwich" of worksheets: =Average(start:end!A1) Then you can drag sheets in and out of that sandwich to play what if games. I'd put a couple of notes on each of these sheets: "don't delete this sheet!" And protect the worksheet so that people don't use it for real data. jb wrote: Need to sum same cell on numerous worksheets w/i a workbook -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum
=SUM(Sheet1:Sheet23!C34)
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 Thu, 19 Jan 2006 11:19:02 -0800, "jb" wrote: Need to sum same cell on numerous worksheets w/i a workbook |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|