This formula works:

=SUMPRODUCT(--(AMS!$C$4:$C$60000="InitialOrderEntry");--(AMS!$Z$4:AMS!$Z$60000=17);--(AMS!$AB$4:$AB$60000=226);--(AMS!$AS$4:$AS$60000=$A$1);--(AMS!$J$4:$J$60000))

When I add this condition: (AMS!$B$4:$B$60000=Summary!C3)

=SUMPRODUCT(--(AMS!$C$4:$C$60000="InitialOrderEntry");--(AMS!$B$4:$B$60000=Summary!C3);--(AMS!$Z$4:AMS!$Z$60000=17);--(AMS!$AB$4:$AB$60000=226);--(AMS!$AS$4:$AS$60000=$A$1);--(AMS!$J$4:$J$60000))

The formula returns "0" - which is incorrect. The data in AMS!$B$4:$B$60000
looks like this - 20060314. The criteria in Summary!C3 is copied from
AMS!$B$4:$B$60000.

What am I doing wrong ?

Thank you in advance.