Cell Reference Error

  • Thread starter Thread starter msherman83
  • Start date Start date
M

msherman83

I realize when I reference a cell from another worksheet and tha
worksheet does not exist, my SUM formula will not work and #REF
appears.

Is there a way for Excel to just count this lack of a worksheet as zer
and allow the formula to work properly?

Thanks,

-Mik
 
Use 2 empty dummy sheets and sum them

=SUM('first:last'!A20)

then place all other sheets between them


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top