Thread: SUMIF Criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emile[_2_] Emile[_2_] is offline
external usenet poster
 
Posts: 4
Default SUMIF Criteria

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