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.