deleted reference

[Guest]

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

 

[Franz Verga]

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

 

[Guest]

Hi Franz,
Thank you - your solution works great.
Cheekycow in the U.S.