Formula to count certain words in a sentance

[Simon]

Is there a formula to count if a certain word is within a
sentence? Countif only counts the whole sentence?
I need this to also do a total count across a sheet.

thanks

 

[Frank Kabel]

Hi
try
=COUNTIF(A:A,"*word*")

 

[hgrove]

Frank Kabel wrote...

try
=COUNTIF(A:A,"*word*")

That's one possible interpretation of what the OP asked, but I'd be
not what the OP wants.

Is there a formula to count if a certain word is within a
sentence? Countif only counts the whole sentence?
I need this to also do a total count across a sheet.

If you want to count the instances of one string, small, inside anothe
string, large, try

=(LEN(large)-LEN(SUBSTITUTE(large,small,"")))/LEN(small