Modifying A Sumproduct Formula

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=Sheet2!$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" <carl@discussions.microsoft.com> wrote in message
news:99F87D6E-46FF-47A3-92A1-C7A036054859@microsoft.com...
> 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.
>