Inventory

[doran313]

I'm trying to keep a running inventory of booze!
We record what is brought up every night and what we bring back down
Then excel calculates how much we've used.
I want to transfer it to a seperate page and subtract it from inventor
for the running inventory but I need it to zero out the used collu
without erasing the inventory or the running inventory so on the nex
night I can do the same. Then I need to be able to add to the inventor
when we recive orders.

ANY HELP!!!!!!!!!!!!!

 

[Tom Ogilvy]

Maintain a list of what you receive and what you sell.

Then use sumif on each list to get the current balance.

=sumif(items,item,qty_receipts) - sumif(items,item_qty,qty_sales)