software

This formula works correctly:

=SUMPRODUCT(--(AMS!$C$4:$C$60000=quot;InitialOrderEntryquot;);--(AMS!$Z$4:AMS!$Z$60000=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=quot;InitialOrderEntryquot;);--(AMS!$Z$4:AMS!$Z$60000=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.

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

quot;carlquot; gt; a écrit dans le message de
...
gt; This formula works correctly:
gt;
gt;
=SUMPRODUCT(--(AMS!$C$4:$C$60000=quot;InitialOrderEntryquot;);--(AMS!$Z$4:AMS!$Z$600
00=17);--(AMS!$AB$4:$AB$60000=226);--(AMS!$AS$4:$AS$60000=$A$1))
gt;
gt; When I add another condition --(AMS!$B$4:$B$60000=Summary!C3) the formula
gt; returns zero - should return a number.
gt;
gt;
=SUMPRODUCT(--(AMS!$C$4:$C$60000=quot;InitialOrderEntryquot;);--(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))
gt;
gt; What am I doing wrong.
gt;
gt; Thank you in advance.
gt;
gt;
gt;
Thanks. That does not seem to be the problem. Any other iedeas ?

quot;Ardus Petusquot; wrote:

gt; Maybe --(AMS!$AB$4:$AB$60000=226);--(AMS!$B$4:$B$60000=Summary!C$3)
gt;
gt; If you use a relative row address, the comparison will take place on
gt; different rows
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;carlquot; gt; a écrit dans le message de
gt; ...
gt; gt; This formula works correctly:
gt; gt;
gt; gt;
gt; =SUMPRODUCT(--(AMS!$C$4:$C$60000=quot;InitialOrderEntryquot;);--(AMS!$Z$4:AMS!$Z$600
gt; 00=17);--(AMS!$AB$4:$AB$60000=226);--(AMS!$AS$4:$AS$60000=$A$1))
gt; gt;
gt; gt; When I add another condition --(AMS!$B$4:$B$60000=Summary!C3) the formula
gt; gt; returns zero - should return a number.
gt; gt;
gt; gt;
gt; =SUMPRODUCT(--(AMS!$C$4:$C$60000=quot;InitialOrderEntryquot;);--(AMS!$Z$4:AMS!$Z$600
gt; 00=17);--(AMS!$AB$4:$AB$60000=226);--(AMS!$B$4:$B$60000=Summary!C3);--(AMS!$
gt; AS$4:$AS$60000=$A$1))
gt; gt;
gt; gt; What am I doing wrong.
gt; gt;
gt; gt; Thank you in advance.
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;