Hi, please help me, I need assistance:

I am trying to find the total number of times a specific word has been
entered in a column. I tried using LEN and SUBSTITUE but it seems like
that only works if it's a single letter?

Here's the details - some one much smarter than I am will surely have
an answer for me?

Word is *Toffee *
(and is written in A1)

The field is *D1 to D600 *(a text formatted column containing single
words in each cell)

-I have had some success with the LEN and SUBSTITUTE formula when using
a single letter but I have had to write out the whole field as
D1&D2&D3&D4&D5... etc, it wouldn't work using D1:D10) - I dont want to
write 1 to 600 with & between each entry - is there another way?-

The Total should be supplied in *B1* (in number format)

Look forward to hearing your response
Cheers
LOSTLADY!




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