BTW, no money is exchanged, only pride.
I set the spread sheet as follows:
Line 1 has all the teams playing, paired.
Line 2 has the final score
Line 3 is each individuals guess
Cell A Is the players name
Cell B is Team A
cell C is team B
Line 4 is a merged cell (A&B) which is in need of the formula.
I'm pretty green, not real well versed in excel, just enough to get in trouble! Initially I tried =(B2-B3)+(C2-C3). That's fine if you always chose a score lower than the actual. If you don't you get a negative numer, which skews the total difference in how far off you were on each game!
It's probably a simple solution, but not for this simpleton.
Thanks for your help!
Edited by bagman, 07 October 2005 - 08:51 PM.