Is it possible to get excel to count the cells in a worksheet which contain a
text similar to a value?

eg If I wanted it to count the number of cells which contains the word
"apples", but in some cells it might be spelt "aples" or "appls"?
I know in that instance I could just run a spell check, but you get the idea.