Hello, i have a problem with excel....

I need to make three cells, Added, Sold and Total.

The cell total needs to be the total amount of cans i have in my shop. So lets say 10.

When i add 5 into the cell Added my total should be 15, this i can do

BUT! when i remove the 5 from the cell added, the total cell has to stay 15, untill i put 5 into the SOLD cell.


Is there a way to do this i'm getting a headache from trying to solve this puzzle