Hi Everyone,

Quick question:

I am trying to convert a 2010 to 2003, and I am using countifs.

I have used to following formula: 

COUNTIFS(MasterList!U:U, "<50", MasterList!X:X, "=0")
And I have attempted to convert it to this using a CSE formula:

=SUMPRODUCT(--(MasterList!U1:U8000<50),--(Masterlist!X1:X8000=0))
My issue is that it is not counting the first criteria. It is only counting the number of 0s in X1:X8000 and I cannot figure out why. The answer should be around 10, and the answer is over 4000...

Thanks in advance for the help.