forumla to count a word that is not stand alone - help

I am trying to get this forumla created and need some help. In my excel file I have a list of companies going down the rows. It starts at k6 and goes down to K10781. I would like to have it show in the cell about that how many times it sees the word ford and could it. I have other business in the different cells, plus why I am asking for when it sees the word ford is because it could be listed like Sawgrass Ford, Ford of Clermont, etc. Any help would be great and hopefully you understand my questions. Thank you.

=SUMPRODUCT(SUBTOTAL(3,OFFSET(K6:K10781,ROW(K6:K10781)-ROW(K6),0,1)),--(K6:K10781="FORD"))

This is what I currently have but it doesn't work because it is only looking for the the exact word Ford not ford in a sentence like the examples I said above.