formulas for office sports pools

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to learn how to take outcomes of weekend football games & assign
them a value of 1 point for each correct location. I have 10 players in this
office pool & there are 32 teams palying on any given Sunday, that 16 games.
After I input their selection under each matchup column, corresponding to
their name; I would like to be able to back to the spreadsheet & type in the
correct outcome, which in turn will return a value of 1 plus the other
correct choices made for the other matchups listed across the top row of the
spreadsheet. The value would need to be added to an open cell at the end of
that players row.

Thank you kindly,
 
Hi!

I also run a pool. The number of participants varies from week to week so
it's kind of a PITA to maintain.

What I do is put in the game scores and then everything gets updated from
there. If you'd like, you can send me a copy of your file and I'll fix it up
for you. I'm kind of bored and looking for a good project. I'm at:

xl can help at comcast period net

Remove "can" and change the obvious.

Biff
 
OPG,
Try this:
Column A Score Column C Score Column E Column F
Team1 Team2 Team1 wins Team2 wins
A 3 H8 6 =IF($B3>$D3,1,0) =IF($D3>$B3,1,0)
B 6 G7 3
C 3 F6 6
D 6 E5 3
E 3 D4 6
F 6 C3 3
G 3 B2 6
H 6 A1 3
I 3 Z 6
J 6 Y 3
K 3 X 6
L 6 W 3
M 3 V 6
N 6 U 3
O 3 T 6
P 6 S 3
Q 3 R 6

Put Name in separate columns to the right.
Just copy the cell from E or F depending on how they picked.
At the bottom of the name columns, =SUM(H3:H19)
As you upate the scores, it will put a "1" or "0".
Good luck, HTH
 
Back
Top