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?
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1