Excel Formula: Conditional Count

C

Chames

Joined
Oct 14, 2010
Messages
1
Reaction score
0
I'd like to count the number of times a certain word appears in a column. This formula:

=COUNTIF(sheet1!E2:E2000,"word")

...seems to count the value if it is the only thing in the cell. I'm looking for a formula that will give the number of times the word appears in the content of the cell. Would this be a =SUMPRODUCT formula?

Thank you, in advance, to anyone who can help me with this!
 
Are you able to use wildcards in the formula:

=COUNTIF(sheet1!E2:E2000,"*word*")

I'm not an Excel expert, but that may help?
 
Back
Top