Excel Simple Calculations help
 

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


--
bobby911
------------------------------------------------------------------------
bobby911's Profile: http://www.excelforum.com/member.php...o&userid=24627
View this thread: http://www.excelforum.com/showthread...hreadid=382144

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


"bobby911" wrote in
message ...

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


--
bobby911
------------------------------------------------------------------------
bobby911's Profile:
http://www.excelforum.com/member.php...o&userid=24627
View this thread: http://www.excelforum.com/showthread...hreadid=382144

Take a look he

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

In article ,
bobby911
wrote:


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