counting multiple instances of one keyword in one cell
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!)
Help Article Resources
Check out the Formula Handbook template!