stock management

I need to set up a simple stock management worksheet that lists quantities of stock held. The quantity needs to update when an item is sold so that a running total is kept of stock quantities. Is there a formula that will do this - or is there a better way?