Sumproduct as Countifs issue

Hi Everyone,

Quick question:

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

I have used to following formula:

Please Login or Register  to view this content.

And I have attempted to convert it to this using a CSE formula:

Please Login or Register  to view this content.

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.

Try

=SUMPRODUCT(--(MasterList!U1:U8000<>""),--(MasterList!U1:U8000<50),--(MasterList!X1:X8000=0))

and it is not array-entered.

The issue was that the SUMPRODUCT formula I used also counted blank cells, but I did not know this was the case...

I just added another criteria to block the cells which were blank.

Please Login or Register  to view this content.

http://www.mrexcel.com/forum/excel-q...t-formula.html