Word Count

[Rohun Heesen]

I have a list of various recipes that I am using to write a food science paper. I have a bunch of other (irrelevant for this question) data that is pertinent to each recipe in 5 other columns. The recipe's ingredients take up one cell with ingredients separated by a comma. I would like to have my spreadsheet count the amount of times a specific ingredient shows up in all of the recipes. The COUNTIF function will not accomplish this since it will not look at one word of many in a single cell. Can this be done easily in excel, or do I need some VBA code to achieve this?

Thanks

[Pauleyb]

Could you use something like:
=countif(A1:A100,"*pear*")

That will tell you how many cells have pear in it, but would not count a cell more than once.

Pauley