It's not the best way to approach this.
You have *no* record of past entries, so how can you check if a mistake was
made, or even if an entry was forgotten to be made.

However, check out this link of John McGimpsey:

http://www.mcgimpsey.com/excel/accumulator.html
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"chris_" wrote in
message ...

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