I use this formula:

=SUMPRODUCT(--(Sheet1!$Y$4:$Y$60000=Sheet2!$G$4);--(Sheet1!$AB$4:$AB$60000="Directed");--(LEFT(Sheet1!$O$4:$O$60000;3)=$G$5);--(Sheet1!$I$4:$I$60000=Sheet2!E11);--(Sheet1!$AC$4:$AC$60000=$G$3);Sheet1!$N$4:$N$60000 )

In the first criteria (Sheet1!$Y$4:$Y$60000=Sheet2!$G$4), is there a way to
ignore the criteria if G4 is blank ?

Thank you in advance.

Try this array formula

=SUM(IF(Sheet2!$G$4="";1;(Sheet1!$Y$4:$Y$6000=Shee t2!$G$4))*(Sheet1!$AB$4:$A
B$6000="Directed")*(LEFT(Sheet1!$O$4:$O$6000;3)=$G $5)*(Sheet1!$I$4:$I$6000=S
heet2!E11)*(Sheet1!$AC$4:$AC$6000=$G$3)*(Sheet1!$N $4:$N$6000))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"carl" wrote in message
...
I use this formula:


=SUMPRODUCT(--(Sheet1!$Y$4:$Y$60000=Sheet2!$G$4);--(Sheet1!$AB$4:$AB$60000="
Directed");--(LEFT(Sheet1!$O$4:$O$60000;3)=$G$5);--(Sheet1!$I$4:$I$60000=She
et2!E11);--(Sheet1!$AC$4:$AC$60000=$G$3);Sheet1!$N$4:$N$60000 )

In the first criteria (Sheet1!$Y$4:$Y$60000=Sheet2!$G$4), is there a way
to
ignore the criteria if G4 is blank ?

Thank you in advance.