Count Cells where cell = "specific value" AND the cell 3 columns over = "different specific value"

[TracyCurrent4]

I don't think I'm able to use countifs on the same data. I have a set of data where I need to find names and count if they won (W) a match. The W will always be 1 or 3 columns to the right of the name. Ultimately, count if any cell = (list of names) and the offsetting cell = "W". The names and outcomes repeat over 5 rows and many columns.

This is a snippet of what the sheet looks like:

 

[Jeffrey Mahoney]

With your format where multiple results are spread across the columns you will have to add multiple COUNTIFS results
=Countifs(B:B.A8,E:E,"W")+Countifs(I:I.A8,L:L,"W") etc.

 

[TracyCurrent4]

With your format where multiple results are spread across the columns you will have to add multiple COUNTIFS results
=Countifs(B:B.A8,E:E,"W")+Countifs(I:I.A8,L:L,"W") etc.

Thank you, I was afraid that might be the case.