If the word "Toffee" can appear more than once in a cell and you want to
know how many times Toffee appears in a range of cells

Ttry this:

=SUMPRODUCT(LEN(D1:D600)-LEN(SUBSTITUTE(UPPER(D1:D600),UPPER(A1),"")))/LEN(A1)

Example:
A1: Toffee and donuts
A2: Toffee is not Toffee-free.

Count of Toffee is 3.

Note: SUBSTITUTE is case sensitive, hence the UPPER function.

I hope that helps.

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=377747