Assuming that your version of Excel uses a semi-colon instead of a comma
as a separator, and that the '4 criteria' refers to Columns Y, AB, I,
and AC, try..

=SUMPRODUCT(--(Sheet1!$Y$4:$Y$903=Sheet2!G$10);--(Sheet1!$AB$4:$AB$903="D
irected");--(Sheet1!$I$4:$I$903=Sheet2!E11);--(Sheet1!$AC$4:$AC$903=60))

Hope this helps!

In article ,
"carl" wrote:

I use this formula:

=SUMPRODUCT(--(Sheet1!$Y$4:$Y$903=Sheet2!G$10);--(Sheet1!$AB$4:$AB$903="Direct
ed");--(Sheet1!$I$4:$I$903=Sheet2!E11);--(Sheet1!$AC$4:$AC$903=60);Sheet1!$N$4
:$N$903)

The values in Col N are not numbers. The formula returns 0 (zero).

Is there a way to modify the formula to count the number of cells that
satisfy the 4 criteria ?

Thank you in advance.