Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting some tabs from sum formula
There are 18 tabs I want to exclude from my 42 tab sum formula. How do I do
this? Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting some tabs from sum formula
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: =Sum(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. So if you put 18 tabs outside that sandwich of Start:End, those values won't be included in the summary sheet. (And just drag them in when you need to.) DGM wrote: There are 18 tabs I want to exclude from my 42 tab sum formula. How do I do this? Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
Indirect formula using Data Validation List of Worksheet Tabs | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Deleting multiple rows through a formula | Excel Discussion (Misc queries) |