This is not a good idea, since you really have no record of what was keyed
in to the cell.
How would you track mistakes?

BUT ... If you really want to do something like this, check out this link to
J.E.McGimpsey's web page on the subject:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"patrick" wrote in message
...
Ok I want A1 to keep a sum of B1 and -C1. Every time I enter a figure in
B1 I
want A1 to add that figure to the total. So if I enter 40 this time the
total
in A1 will equal 40. Now I want to enter 20 in B1 tommorow and I want A1
to
equal 60. How I have it set up now is that when I enter 20 in B1 A1 will
say
20. I want A1 to keep a running total of the entries in B1. Everytime I
make
an entry in B1 I want A1 to add this entry to its total. I put 20 in B1
today
A1 reads 20. I put 20 in B1 tommorow A1 reads 40, I put 20 in B1 the next
day
A1 reads 60. Then the same for C1 only I want C1 to subtract. Lets say A1
reads 60 and I enter 20 in C1 now A1 will read 40
the next time I enter 10 in C1 now I want A1 to read 30. Running totals is
what I need.
Thanks alot for you help by the way I hope I explained this well enough

"Patrick" wrote:

I am creating a spreadsheet for my acount payables and recievables. I
want to
designate a cell to keep a total.
I need one cell whenever I add a figure it add to the total and another
cell
whenever I subtract a figure it will subtract from that same cell.