Maybe --(AMS!$AB$4:$AB$60000=226);--(AMS!$B$4:$B$60000=Summary!C$3)

If you use a relative row address, the comparison will take place on
different rows

HTH
--
AP

"carl" a écrit dans le message de
...
This formula works correctly:


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

When I add another condition --(AMS!$B$4:$B$60000=Summary!C3) the formula
returns zero - should return a number.


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

What am I doing wrong.

Thank you in advance.