Copy Item Number And Calculate Price As Replenished

Hello, attached is my spreadsheet. What I would like it to do is when someone marks a "N" or some other symbol in the box showing that supply not there; that excel copies the item #'s for the products listed and calculates up the prices for those items.
Thank you in advance for your help. If at all possible if it could calculate the order on another sheet such as sheet 3 that would be fantastic

Faud

Re: Copy Item Number And Calculate Price As Replenshied

Thanks for the replay Rex. I will try better to explain what I mean. Ive also reattached the spreadsheet with prices and one column with the "Y"s or "N"s.

The "Y" or "N" is a reference as to weither or not that product was in the first aid kit. If the product is "N" I would like a macro that will generate a total amount for all of the products marked "N" in all of the 4 first aid kits.

Thanks again,

Faud

Re: Copy Item Number And Calculate Price As Replenshied

Is there a way to modify the SUMIF function to add up colum H if the conditions are met in Column D ?

Thanks guys

Faud

Re: Copy Item Number And Calculate Price As Replenshied

That worked perfectly ! You have made my day ::D

Thank you

Faud