Need help with Counters

  • Thread starter Thread starter Vic
  • Start date Start date
V

Vic

I have a list of names from A8 thru A70. For each name I need to put in M8
thru M70 counters of how many occurences of those names from D146 thru D1465
I have. But only count the ones that have "1-Yes" in the corresponding J146
thru J1465.

I am trying to put this one in M8 but it does not work:
=SUMPRODUCT((D146:D1465=A8:A70)*(J146:J1465="1-Yes"))

Please help me to fix it. I need this very urgently.

Thank you.
 
Try:
=SUMPRODUCT((ISNUMBER(MATCH(D14:D1465,A8:A70,0))*(J14:J1465="1-Yes")))
Success? hit the YES below
 
You just need to delete ":A70" resulting in:

=SUMPRODUCT((D146:D1465=A8)*(J146:J1465="1-Yes"))

Tom
 
Better, use this and copy it down to cell M70:

=SUMPRODUCT(($D$146:$D$1465=A8)*($J$146:$J$1465="1-Yes"))
 
I used this =SUMPRODUCT(($D$146:$D$1465=A8)*($J$146:$J$1465="1-Yes")) copied
that down from M8 thru M70, and I still get zeroes in M8 thru M70.
What is the fix for this?
Thanks
 
Back
Top