TracyCurrent4
New Member
- Joined
- May 20, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
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:
This is a snippet of what the sheet looks like: