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