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. :)

On Jun 6, 4:56 pm, Kath wrote:
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. :)


Did you see the response in your other post?

Thank you very much, sorry for the late reply and the seeming double post
but for some reason I had been unable to see any new posts after I posted my
original one until just now.

Thank you again. The formula works perfectly.

"vezerid" wrote:

On Jun 6, 4:56 pm, Kath wrote:
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. :)


Did you see the response in your other post?