Sum if the cells are not blank for specific products

[Goddess]

Hi, I need to sum if only both cells (B & C) are not blank. Some rows are totally blank, as we need to export the data from a system, thus there will be some weird formatting. Example as below

Sheet1:

In the example above, I need the result to return in another sheet as below:

Sheet 2:

Basically, only sum B & C if both columns have value in them (even if it's 0), and only for specific products as indicated in Sheet 2. Sheet 1 may have other products which I do not need.

Thanks!
Irene

 

[Goddess]

Hi Alex,

Thanks! it worked!

Hi Habtest,

Not sure why it returned a different figure. hmmm... Anyway, thanks too!

 

[Alex Blakenburg]

Thanks for the feedback. Glad we were able to help you.
It would have been interesting to know why the SumProduct Habtest sent you didn't give the same result for future reference. It looked to be working when I tried it on my small set of data. If you have the inclination and still have it in your spreadsheet somewhere, can you send us the sumproduct formula as you had it in your spreadsheet. Don't go to any trouble though it is just for interest.

 

[Goddess]

Thanks for the feedback. Glad we were able to help you.
It would have been interesting to know why the SumProduct Habtest sent you didn't give the same result for future reference. It looked to be working when I tried it on my small set of data. If you have the inclination and still have it in your spreadsheet somewhere, can you send us the sumproduct formula as you had it in your spreadsheet. Don't go to any trouble though it is just for interest.

Hi Alex.

So sorry, I've deleted the sample file.. it returned a value that I can't figure out where it came from...

 

[Alex Blakenburg]

No worries, thanks for trying, it was more just a nice to know. Have a great weekend.