Formula tweek index match formula needs to also be a sumif

MZING81

New member
Joined
Mar 27, 2012
Messages
40
Reaction score
0
Points
0
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

New member
Joined
Dec 30, 2011
Messages
121
Reaction score
0
Points
0
Location
Victoria, Canada
Excel Version(s)
Microsoft Excel 2013
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,
 

MZING81

New member
Joined
Mar 27, 2012
Messages
40
Reaction score
0
Points
0
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,

thank you so much it worked perfectly!!!
 
Top