IE:

GAME:1 vs 2 3 vs 4

1. Player 1 1 4

Say team #1 and #3 wins, player 1 would have 1 win out of 2 possibilities. Is there any formula to add the wins only up? The way im doing it now is im using the find and replace feature and replacing all the winners with a "1" and all the losers with a space and then using the sum function to add all the "1"s up, which takes a bit of time.

Thanks for all your help.