Sum common products

[Rudi]

Hi,

I need to find the sum of "Spritz" and "Green", which is the base name for paint products that can have various names as in the samples. I have worked out this formula (below) which I need to autosum down the column, but ideally would like just the one calc to exist and recalculate in C9 and C10 to calculate the total value of "Spritz" and "Green" products.

Is there any other calc to do the job better? TX

{=SUM(IF(ISERROR(FIND(B1,$B$1:$B$7)),0,1)*$C$1:$C$7)}

[sdckapr]

How about the formula:
=SUMIF($B$1:$B$7,"*"&B9&"*",$C$1:$C$7)

[Rudi]

Wow...

That is something I did not think of! Wildcards in a formula! Awesome Steve....Cheers!