AlienBeans,

I would set up a lookup table.

Check Debra Dalgleish's site for a great explanation:
http://www.contextures.com/xlFunctions02.html

Basically, I would probably set up one set of column headings like: GameID,
Team1, Team2, Winner, PointValue. Enter the week's games here.

Then another set of column headings like: Player, GameID, Pick, Points

Then use a VLookup function to return the points for each pick by a player.

Then I would either use a PivotTable on the player pick table to summarize
the data, or you could use some SumIf functions. I would use a Pivottable
personally.

HTH


"AlienBeans" wrote:


I'm not that knowledgeable on excel, and need a little help. I'm
confident Excel can do what i want, just don't know how to get it set
up.

I run a weekly college football pickem contest and want to set up excel
to do the scoring for me. We pick multiple games every saturday, and
some games are worth 1 point, and more important games are worth more.
What I want to do, is be able to set up these matchups and point value
for each, then when the games are over, simply type in the winner, and
have it match every player that has that team and add the respective #
of points. See, I have anywhere from 20 to 50 people a week
participating, and it takes forever now to score all players entries.
Can somebody here help me set this up? Thanks in advance.


--
AlienBeans
------------------------------------------------------------------------
AlienBeans's Profile: http://www.excelforum.com/member.php...o&userid=32352
View this thread: http://www.excelforum.com/showthread...hreadid=521080