Matching cells - formula help

A very helpful poster showed me how to use the index and match to count the number of 'Red' games for each player's individual stats page: =COUNTIF(INDEX(Results!$1:$1000, MATCH($B$1, Results!$A$1:$...