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

"Office Pool Guy" wrote:

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,