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:$A$1000, 0), 0), "Red")

Which I have adjusted to:

=SUM(INDEX(Results!$1:$1000,MATCH($B$1,Results!$A$1:$A$1000,0),0))

This counts the combined number of 'goals' and 'assists' for each, but I would like those numbers separately. I have tried adding 

*IF(MOD(COLUMN(),3)=1,1,0)

in various places in the formula but can't get it to work. Any help much appreciated.
(I would also eventually like to be able to count the number of 'goals' each player has scored while playing for the blue team if anyone has any ideas