G
Guest
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?
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?