Paging daddylongleggs - lookup question part 2

ddll - you helped me with the formula for Red Chips (column N) in the attached spreadsheet, but I needed it to do more and forgot to ask. I need the red chips to be award to each individual only once per month AND only if the individual earned at least 1 white chip during the same month. Can you (or anyone) please help?

in N2 it can not happen so 0
in n3 put

=IF(AND(SUMPRODUCT(($F$2:F2=F3)*($C$2:C2=C3)*($H$2:H2=H3)*($N$2:N2))=0,SUMPRODUCT(($F$2:F3=F3)*($C$2:C3=C3)*($H$2:H3=H3)*($I$2:I3>0))>0),IF(COUNTIF('red chips'!A$2:A$13,A3),VLOOKUP(A3,'red chips'!A$2:H$13,8,0),0),0)

and then copy down

Does that work?

Regards

dav

Thanks Dav... I pasted it in and works up until the last record. Also, the example is just a snippet of the original. The original may have 10 times the number of rows and will encompass every month of the year. I will play with putting your suggestion into the real thing.

Interestingly, the forumula does not work in all instances. Most, but not all.