Thank you so much for your replies . They are great but I still have a
problem. The formula works perfectly if there is only one item and we want to
increase and decrease the stock value but the current scenario is:
A B C D E
item opening stock shipped out shipped in current stock
item a 100 20 0 80
2nd transaction 0 40 120
item b
item c
item d
item e

I have ONLY CELL C3 AND D3 TO INPUT DATA AND I THINK E3 should keep updating
itself to reflect the data for c3 and d3. I have to do in a single line each
time and the result to be reflected in current stock.

I have to do this for each of the other items. Am i complicating things or
is there any easy way to go about this.

thanks a ton and I appreciate your help answers.any advise.

vandy
"vandy" wrote:

Hello,

I am trying to calculate the stock inventory of items in my company. I have
imported data from access into excel and attemting to calculate the stock
increase and decrease value.

Eg


CURRENT STOCK = 200
ITEM SHIPPED OUT = 20

CURRENT STOCK = 220

ITEM SHIPPED IN = 100
CURRENT STOCK = 120

It should change according to the qty shipped our or shipped in and should
show current inventory stock for each item in excel.

Can anyone please help with the formula to be used for the same.

thanks in advance.