hello

I'm using the COUNTIF function to count the number of instances of a particular word in a range of cells. However I only want to count that word once if it appears more than once in a cell. For example

A1 apple
A2 pear
A3 red apples and green apples
A4 banana

Using COUNTIF(A1:A4,"*apple*") to find how many cells contain the word "apple" (doesn't matter if singular or plural) gives the answer of 3 (1 in A1 & 2 in A3) whereas the desired answer is 2. This being derived from A1 & A3 both containing the word "apple" irrespective of how many times it occurs in any given cell.

Thanks in anticipation