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!