Hi,
I'm running a friendly pool for NFL picks. Each week , you pick 10 games and depending on the point spreads, wins are worth 5, 3 or 1 points. A loss is worth -3 points no matter what.
I've got a sheet set up (attached) that is calculating how I would like it to, but my problem is the formula is counting -3 points for games that are not picked (should be 0, each person only picks 10/13 or 14 game each week).
I know I'm missing something but can't seem to recall for college.
Please take a look and let me know how I can get this to work.
Thanks in advance.
Bookmarks