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!


--
chris_
------------------------------------------------------------------------
chris_'s Profile: http://www.excelforum.com/member.php...o&userid=25009
View this thread: http://www.excelforum.com/showthread...hreadid=385357