counting multiple instances of one keyword in one cell

Shannon Petersen
Shannon Petersen ✭✭✭
edited 06/24/20 in Formulas and Functions

I'm trying to count the number of instances of a keyword in one cell (for instance if I have "Green Apples; Yellow Bananas; Brown Bananas; Reg Apples" in my Products column for this row, I want to count the number of times "Apples" appears in the Products cell for this row, which should be 2).

I'm using this formula:

=COUNTIF(Products1:Products1, FIND("Apples", @cell) > 0)

And it's giving me a count of 1 regardless of how many instances of the keyword "Apples" I have in my Products cell. (I suspect "1" means it counted 1 cell with the word, so I think I know what I'm getting, but I don't know how to get what I actually want!)

Any advice?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!