Count number

[mark0123]

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

I have attached a spreadsheet.upload.xlsx

[Richard Buttrey]

Hi,

It's not clear where you want the results, nor indeed precisely what results you do want.

Would you manually add them and upload the workbook?

[FDibbins]

Hi, welcome to the forum

Not sure if this is what you want, I put this in M2...
=COUNTIFS(B3:K3,"N",$B$1:$K$1,1)

[FDibbins]

This will work as well...
=SUMPRODUCT(($A$3:$A$9=A3)*($B$1:$K$1=1)*($B$3:$K$9="N"))

Or, if you want to hard-code the name...
=SUMPRODUCT(($A$3:$A$9="Alan D")*($B$1:$K$1=1)*($B$3:$K$9="N")