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!