Formula to count certain words in a sentance

  • Thread starter Thread starter Simon
  • Start date Start date
S

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 wrote...
try
=COUNTIF(A:A,"*word*")
Click to expand...

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

Simon said:
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.
Click to expand...

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

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