Hi,

I need something which looks-up the name and wk and then shows the count on N or O per person. For example Alan D has 2 N's in week one.

This is what I have; SUMPRODUCT(--(Data!A2:A6=*person name*),--(Data!B1:B10=Wk1),--(B3:K7=N)). Thank you


WK1 Wk1 WK1 WK1 WK1 WK2 WK2 WK2 WK2 WK2
Alan D N N - - - P - P P -
Peter p - - - P - - - P P N
Paul H - - - - P P N - -
Mary B - - - - - - - P - N
Steve C - N - - - P N P P -
Sonia W - - - - P P - P - -
Frank F - N - P P - - - - P