Problem w/ A Sumproduct Formula

[carl]

This formula works correctly:

=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))

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$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.

[Ardus Petus]

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" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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.
>
>
>

[carl]

Thanks. That does not seem to be the problem. Any other iedeas ?

"Ardus Petus" wrote:

> 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" <[email protected]> a écrit dans le message de
> news:[email protected]...
> > 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.
> >
> >
> >
>
>
>