Hi
Can anyone help me:
I wish to create a very simple to use goods in/ out spreadsheet.

Each row will be a different part number.

Column A = Part Number
Column B = Amount of Goods In
Column C = Amount of goods out
Column D = Current Stock Held

What I want it to do is to add up the quantity each time goods arrive in one
cell (cumulatively)and then do the opposite when goods go out. Then subtract
Column c from Column B to give me a running total (Column D).

Anyone know the formula?