Hi All........
In XL2k, I have a 3500 line database and the rightmost 2 columns I insert
two large SUMPRODUCT formulas. One is wrapped with an ISERR statement and
the other is part of a LOOKUP formula. Both were written ok and were WERE
WORKING FINE FOR A COUPLE OF WEEKS. All of a sudden they don't work.

I've taken that same sheet out of an old version of the workbook where the
SUMPRODUCT formulas are still working and put it in this workbook and it
works fine as long as the SUMPRODUCT formulas are still referring to the
older workbooks database, but when I copy them over to the current database
sheet they fail just as the original ones do. This is pretty important to
me as I use the results of these formulas as a basis for many "Reports".
Any ideas?.......

TIA
Vaya con Dios,
Chuck, CABGx3