Running totals in excel

[chuck2]

Good afternoon all.

I need a little assistance with using spreadsheets to keep an
inventory updated. I have 7 column headings each referring to a
different type of equipment. I have another column for a date, one
representing whether the the equipment was shipped or received and
finally which facility was receiving or shipping the product.
So in each row I would enter a date, how many pieces of equipment was
either shipped or received and then the shipping / receiving facility.

My questions are, how would I keep a running total of a particular
facilities current inventory with so many shipments and deliveries?

Secondly, would it be easier to make a different worksheet for each
facility? And keep track that way?

This is the first time using this forum so any help would be greatly
appreciated.

 

[Niek Otten]

This is not the type of problem Excel is very well suited for.
But it can be done; check:

http://www.mcgimpsey.com/excel/accumulator.html