Excel Formula: Conditional Count

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!
 

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,873
Reaction score
1,499
Are you able to use wildcards in the formula:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top