Adding or subtracting to a total after a specific date under certain conditions
I'll try to put this as easy as I can. I'm in a football pool this season and I'd like to keep track of my totals in Numbers. I pick 5 games a week. If I get 1 pick correct, I get 1 point, 2 picks, 2 points, etc.
However, if I get 5 picks correct, there is 1 bonus point added to 5.
I've figured it out up to this point.
Here is where I'm having trouble. If I get zero picks correct for the week, I get a -1 for the week. Since none of the boxes will be checked before the week starts, I don't want it to start out with a total of -1. I want it to show 0. The first week is over on 9/14/15. How can I get my total to show -1 only after the week is over if I didn't get any picks correct? I hope this makes sense. I've been at this for almost an hour and I've gotten close, but can't seem to get it right.
MacBook Pro (Retina, 13-inch, Mid 2014), OS X Yosemite (10.10.2)