Problem w/ A Sumproduct Formula

G

Guest

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with a SUMPRODUCT Formula 8
Modifying A Sumproduct Formula 1
Index, Match 1
Scrabble Value calculation for Welsh words 0
sumproduct with partial charcter matching 3
Choose From a Range 3
OR in SUMPRODUCT formula 3
Problem with if statement 12

Top