Might help to post your formula

--
Don Guillett
SalesAid Software

"Ang" wrote in message
...
I have a formula using SUMPRODUCT which was working and, unfortunately, is
no
longer working and I don't know why. Instead of real values, all I get
now
is all zeros. I haven't changed the formula. The data sheet where the
info
is, changes daily but shouldn't affect my formula, correct? I looking at
HELP in Excel and I'm wondering if this has anything to do with my issue:

SUMPRODUCT treats array entries that are not numeric as if they were
zeros.

Any ideas out there on why this wouldn't be working any longer?
Thx for your expertise!