Hello,
I am having issues using IF and COUNT statements. What I am trying to do is use the Player Stats tab as a raw overview screen which sums together the values in the Raw Data tab.
My current question is for the Games Played column in the This Tournament section of the Players tab. The logic I am going with is:
On the Raw Data tab, If tournament# = 1 and If Player Name in column B or C matches the name from column A on the Player Stats tab
Then count for that row under columns E through J on the Raw Data tab, the number of cells with a value >=21
The idea is to repeat this logic across all rows against the raw data tab, based on the attached file, I would expect the count for Billy to appear as 3. I feel like I am missing something very simple.
Thank you in advanced for your help. I am looking forward to your responses.
test file.xlsx
Bookmarks