SUMIF Criteria

[Emile]

In the criteria section of the SumIF function I would like to look for text
in the range of cells than contains a word or words. I know how to look for
a single word, but do not how to look at a text string that contains certain
text

ie. In the range I may have cells that contains "chocolate fudge brownie"
and "chocolate fudge popiscle" and "chocolate fudge peanuts" plus many other
text entries

I want to sum only the cells based on the range of cells containing
"chocolate fudge"

Thanks in advance for your help

 

[Peo Sjoblom]

Use wildcards

=SUMIF(Range1,"*textstring*",Range2)