Formula to lookup & sum items with same refrence number

Lookup & Sum ALL items that have Selling price greater than Zero.xlsThanks that formula works fine ..... I now need to write another formula that will Total ALL the items that have Sell price greater than Zero (0). So the total should in cell B25 should be 424

Please Assist me with this.

Thanks
Headley

Thanks that formula works fine ..... I now need to write another formula that will Total ALL the items that have Sell price greater than Zero (0). So the total should in cell B25 should be 424. See file attached

Please Assist me with this.

Thanks
Headley

Can any Experts online help me with my question

Thanks in advance.
Headley

---------- Post added at 07:15 PM ---------- Previous post was at 07:14 PM ----------

Can you help me with my question

Thanks in advance.
Headley

Thanks for your quick response HOWEVER I need to be able to type in the product item number in the formula and get the sum total for all of them that have a selling price greater than zero. These products are located all over on a massive file that import at the end of each week. The excel file i had attached is just small extract so you could have an idea of what i want.

Thanks again for you help

---------- Post added at 07:47 PM ---------- Previous post was at 07:40 PM ----------

I need to be able to type in item numbers {8030,8050,8060,9000} in the formula and get the total sold for the ones that have a selling price greater than Zero. So i would get 424. I will also use this formula for other products that we sell

Many thanks again.
Headley

Thanks the formula you gave me worked OK for that situation.
I now need another formula that will allow me to type in a list of item numbers and get the total sold for the ones with selling price greater than zero.
Example : I want to be able to type in item numbers {8030,8050,8060,9000} in the formula and get the total sold for the ones that have a selling price greater than Zero. So i would get 424 in cell B25. I will also use this formula for other products that we sell.

Hope i have explaine it clear.

Thanks in advance.
Headley

Greetings your formula is good but there is one slight problem. If there is an error message in cell C or D eg: (#N/A or #REF!) The Total sold also shows this error message in (cell B25).

Can the formula be adjusted to ignore these errors so i can get the Total Sold in cell (b25) and not the Error message.

Thanks A lot.
Headley

Greetings your formula above is good but there is one slight problem. If there is an error message in cell C or D eg: (#N/A or #REF!) The Total sold also shows this error message in (cell B25).

Can the formula be adjusted to ignore these errors so i can get the Total Sold in cell (b25) and not the Error message. Please see attached file again.

Thanks A lot.
Headley

Thanks for replying. If the error is in column "D" the formula dosent works it reflects the error in the tolat box ( cell B25). I need it to work whether the error is in column "C" or "D"


Thanks Again
Headley

Thank You Very Much. The Formula Works wonderfully.


Thanks again for your help.
Headley