Formula tweek index match formula needs to also be a sumif

Hello everyone,

I have this formula which works well for one indiviual instance. But if there are multiple occruences for a specific indivual it will not some all their occurences of "PAID" only the first.


{=IFERROR(INDEX('SHEET1!$F$2:$F$6000,MATCH(D6&A6&"PAID",'SHEET1!$A$2:$A$6000&'SHEET1!$B$2:$B$6000&'SHEET1!$G$2:$G$6000,0)),"")}

Any Help would be greatly appreciated.

MZING81

MATCH doesn't do multiple occurances.

How about this:


Cheers,

cheshirecat said:

match doesn't do multiple occurances.

How about this:

Code:

=sumproduct(sheet1!$f$2:$f$6000,--(sheet1!$a$2:$a$6000=d6),--(sheet1!$b$2:$b$6000=a6),--(sheet1!$g$2:$g$6000="paid"))

cheers,

Click to expand...

thank you so much it worked perfectly!!!