Checking for words and multiplying by a cell

[Takron]

I am checking for words in a column using this function: =COUNTIF(C7:C33,"*Colorless*") or =COUNTIF(C7:C33,"*Blue*")

When the word is detected within the range I have them output to a cell that labels what the word was and the amount so if it was 'Blue' then the label would be [Blue][6] if it detected 6 instances of Blue within the range. What I want to do is, when the word is detected, I want the word it detects to get multiplied by the number of the cell next to it. So if it detects blue and there is a 2 in the cell to the left, I want the countif to count it as two instances of blue, not just one and then add it to the total.
[2][Blue]
[2][Green]
[4][Colorless]
[1][Blue]
[4][Blue]
[3][Red]
If those were cells I would want the output to be [Blue][7] not [Blue][3]

 

[Aladin Akyurek]

I am checking for words in a column using this function: =COUNTIF(C7:C33,"*Colorless*") or =COUNTIF(C7:C33,"*Blue*")

When the word is detected within the range I have them output to a cell that labels what the word was and the amount so if it was 'Blue' then the label would be [Blue][6] if it detected 6 instances of Blue within the range. What I want to do is, when the word is detected, I want the word it detects to get multiplied by the number of the cell next to it. So if it detects blue and there is a 2 in the cell to the left, I want the countif to count it as two instances of blue, not just one and then add it to the total.
[2][Blue]
[2][Green]
[4][Colorless]
[1][Blue]
[4][Blue]
[3][Red]
If those were cells I would want the output to be [Blue][7] not [Blue][3]

Try...

=SUMIF($B$2:$B$7,"Blue",$A$2:$A$7)

where color items are in B2:B7 and numbers in A2:A7.

 

[Takron]

Thank you, that worked wonderfully.

 

[Aladin Akyurek]

Thank you, that worked wonderfully.

You are welcome. Thanks for providing feedback.