Hi,

I am running Office 2007 and I am trying to find a formula that will allow
me to keep track of my current stock of craft materials.

The workbook is set up as follows.

Sheet named "Stock"
ID # | Item Name | Start Count | Stock Remaining | Cost per unit

Sheet named "Creations"
ID # | CREATIONS | QTY Used | Unit Cost | Totals

"Stock" sheet is sorted alphabetically.
"Creations" sheet is sorted according to product created and is no
alphabetical.

Considering that it is entirely possbile to use the same stock item within a
number of creations, the stock item may be present in multiple places on the
"Creations" page. This is where I hit my snag. I can't seem to get a
formula to add up all the stock used of one particular item and then subtract
that total from the start count.

Any help would be gratefully appreciated.

Thanks. :)