Formula to count instances of a word

mjensen ✭✭
edited 12/09/19 in Formulas and Functions

I have a sheet that is referencing another sheet to provide counts on instances of certain values in different columns. 

What I'm stuck on is counting how many times a single word is used if other text is in the same cell.

For example if I have a column call Fruit and I want to know how many cells contain the word "apple" or "orange" but the cells might have red apple, green apple, granny smith apple, etc... I just want to know how many apples there are without having to have a formula for every variety of apple.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!