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)}
Sum common products
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Sum common products
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 392
- Joined: 25 Jan 2010, 12:21
Re: Sum common products
How about the formula:
=SUMIF($B$1:$B$7,"*"&B9&"*",$C$1:$C$7)
=SUMIF($B$1:$B$7,"*"&B9&"*",$C$1:$C$7)
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Sum common products
Wow...
That is something I did not think of! Wildcards in a formula! Awesome Steve....Cheers!
That is something I did not think of! Wildcards in a formula! Awesome Steve....Cheers!
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.