If Statements

[DPAnders87]

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.

[Richard Buttrey]

Presumably

IF(G4="",0,IF(G4=$A4,1,-3))