Negative Entry to calculate remaining inventory

[Guest]

Here is what I am looking to do, I am tracking inventory via a spreadsheet, I
would like to be able to put an entry on the totals cell and it will then
calculate the remaining amount. So my total inventory is 1000 and I sell
250, I can input the 250 on the Total Cell (currently 1000) and it will
subtract the total remaining giving me 750 in the totals cell. Is this
possible? Any other suggestions on what I might do here? Thanks a lot in
advance.

 

[JE McGimpsey]

See

http://www.mcgimpsey.com/excel/accumulator.html

but be aware that any mistakes will not allow you to easily recover.

 

[Guest]

No you can't do what you are asking but you could insert a couple of rows one
would be a new total row and the other would be your inventory change row.
You would put a formula like this in the new totals row =A1+C1

(This is assming that your previous total was in A1 and that the change to
the inventory was entered in C1). After you have entered all of your
inventory changes you would need to either copy...paste values the new
inventory into your inventory row or create a macro that might do this for
you.

(If you are lowering the inventory you would have to enter a - number, a +
number if you are increasing the inventory.)