C
chris_
At work we have a competition and we keep up with a set of points we get
each day.
I want to create a worksheet that looks like this:
Name | + | - | Total Points
I want to be able to simply enter 3(or any number) in the Plus column
have it add to the total points, keep that running total, and clear the
3 that i put in there so it will be ready for tomorrow.
The same goes for the minus, I want to be able to deduct these points
from the Total Points, then clear the number i entered in the minus
field, saving the running total...
I'm fairly good with the basics of excel, but i couldn't think of a
formula that would keep a running total, while clearing the entered
information.
Thanks in advance!
each day.
I want to create a worksheet that looks like this:
Name | + | - | Total Points
I want to be able to simply enter 3(or any number) in the Plus column
have it add to the total points, keep that running total, and clear the
3 that i put in there so it will be ready for tomorrow.
The same goes for the minus, I want to be able to deduct these points
from the Total Points, then clear the number i entered in the minus
field, saving the running total...
I'm fairly good with the basics of excel, but i couldn't think of a
formula that would keep a running total, while clearing the entered
information.
Thanks in advance!