I just want to know if there is a formula that i can use for a free NFL pool I do with some buddies. I want to have numbers for each NFL team, If Player #1 picks team 1, and team 1 wins is there any way to calculate everybodies wins?
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.
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.
