Excel Simple Calculations help

[bobby911]

Hi Guys, thanks for looking. Im creating an inventory stock list for m
fresh produce company and have a list of products with a column o
'stock on hand'. I also have two other columns, one which takes awa
sold Quantities of produce from the total stock on hand, and one tha
adds to it. Now the problem is that as i sell the products i want t
take away from the stock on hand, i use a simple formula whic
subtracts the sold from stock on hand. but i want it doing 'calculato
style' so that i can type a number, say i sold 7 of an item, i typed i
in the sold cell, press enter and it would be gone yet taken away fro
the total stock on hand, but what happens is the quantity stays in th
sold cell, it does not clear off. can anybody help me, any help i
always appreciated. Cheers. :

 

[Anne Troy]

Hi, Bobby. By doing that, you realize you lose any history you might have?
You might be better off keeping one worksheet of how many you sell each day,
and how many you add each day (or week or whatever). You could have a sold
and bought column or just use negative numbers for the sold. In this way,
you keep a history. Then, in some other cell, you have something like
=sum(c2:c65536) if you have the bought and sold all in one column; or you
might have =sum(c2:c65536)-sum(d2:d65536) where you have the boughts in
column C and the solds in column D. But the minute you want to update a cell
with a new value...you don't enjoy having a history. What if a glitch
occurs? You won't remember if you just subtracted those 50 heads of lettuce
or not!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[JE McGimpsey]

Take a look here:

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