Reference Error Removing Formula

[kris.king]

Hello,
I am referencing data on another sheet and from time to time I need to
remove the data. However, when I do so I recieve reference errors on my
formula's and my ranges are removed and I have to readd them. Is there
something I can add to my formula so it doesn't remove the range of
cells I have set?
Here is an example of my formulas:
=SUMPRODUCT(('Solution Direct Tracking'!J2:J5000="Spring
'07")*('Solution Direct Tracking'!T2:T5000=71))

Thanks for the help.

Kris

 

[Max]

Try "fixing" the ranges using INDIRECT, then it'll always point
correctly, eg:
=SUMPRODUCT((INDIRECT("'Solution Direct
Tracking'!J2:J5000")="Spring'07")*(INDIRECT("'Solution Direct
Tracking'!T2:T5000")=71))