Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleted reference
Hello, In a template I am designing I have a summary tab with formulas that
reference amounts from several different detail tabs. However, my beta testers sometimes delete a few of these detail tabs as superfluous if there is no data to input in them. How do I write my formula on the summary tab so that it still works (totaling the amounts from the non-deleted tabs) even if one of the referenced detail tabs is deleted? (Right now the formula on the summary tab shows #REF! because it cant find one of the tabs.) It is almost as if I need to write an €œIF€ formula in the event that one of the referenced cells no longer exists. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleted reference
Cheekycow wrote:
Hello, In a template I am designing I have a summary tab with formulas that reference amounts from several different detail tabs. However, my beta testers sometimes delete a few of these detail tabs as superfluous if there is no data to input in them. How do I write my formula on the summary tab so that it still works (totaling the amounts from the non-deleted tabs) even if one of the referenced detail tabs is deleted? (Right now the formula on the summary tab shows #REF! because it can't find one of the tabs.) It is almost as if I need to write an "IF" formula in the event that one of the referenced cells no longer exists. Thanks Hi, I think you could use something like this: =IF(ISERROR(your_formula);"";your_formula) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
deleted reference
Hi Franz,
Thank you - your solution works great. Cheekycow in the U.S. "Franz Verga" wrote: Cheekycow wrote: Hello, In a template I am designing I have a summary tab with formulas that reference amounts from several different detail tabs. However, my beta testers sometimes delete a few of these detail tabs as superfluous if there is no data to input in them. How do I write my formula on the summary tab so that it still works (totaling the amounts from the non-deleted tabs) even if one of the referenced detail tabs is deleted? (Right now the formula on the summary tab shows #REF! because it can't find one of the tabs.) It is almost as if I need to write an "IF" formula in the event that one of the referenced cells no longer exists. Thanks Hi, I think you could use something like this: =IF(ISERROR(your_formula);"";your_formula) -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Circular reference toolbar not working | Excel Discussion (Misc queries) | |||
a cell reference in a 3d reference | Excel Worksheet Functions | |||
Flexible Cell Reference | Excel Discussion (Misc queries) | |||
Absolute Worksheet reference number | Excel Discussion (Misc queries) |