Using text in a cell as criteria in SUMIFS

Hi! I am struggling to find a solution to taking the text in a cell instead of just writing text to use as a criteria in a SUMIFS formula.

For example,

Screen Shot 2014-10-16 at 9.53.16 AM.png

I can use the formula =SUMIFS(B1:B7,C1:C7,"*stream*") to get what I want, but what if I put the word stream into a cell?

Is there any way to reference the text that is in the cell, such as =SUMIFS(B1:B7,C1:C7,"E13")? The problem is that the string of letters stream can appear anywhere in the cells in column C.

Any help would be greatly appreciated! Thanks!

I think I figured it out - =SUMIFS(B1:B8,C1:C8,"*"&E13&"*")

Thanks!

use this formula in cell where you want to your result

=SUMIFS(A1:A10,B1:B10,D1)

and in d1 ="*"&C1&"*"

searching text in column c1