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

Use wildcards

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


--
Regards,

Peo Sjoblom


"Emile" wrote in message
...
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