If I understand what you want... Excel formulas return results based on the
numbers actually in the spreadsheet. If all your purchases and sales are
entered in individual cells Excel can certainly do the math. But it cannot
do a running total of amounts in the cells and amounts that used to be in
those cells. You'd need a macro to do an 'accumulator'. (But for my money
it's better to have a complete history so you can recreate the current total
if needed).

--
Jim
"Marcus1" wrote in message
...
| 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?
|
|
|