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