Formula tweek index match formula needs to also be a sumif

[MZING81]

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

[CheshireCat]

MATCH doesn't do multiple occurances.

How about this:

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

[MZING81]

match doesn't do multiple occurances.

How about this:

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

thank you so much it worked perfectly!!!