Good day,

I have a sheet with numerous text strings all in the same column. I need to
search each and return the number of occurances (total) of the words
"medicare" and "eomb" cointained in each string.
I've tried this function:

=COUNTIF(A1:A10,"*medicare*")+COUNTIF(A1:A10,"*eom b*")
but it only counts 1 occurance of each. I need to the total times the word
'medicare occurs plus the total times 'eomb' occurs.

Any suggestions?