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?
 

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

Similar Threads

Excel Formula - Count Dates from another Sheet 8
Excel Need Countifs Formula Help 0
Excel VBA 1
Excel Use COUNTIF across a range of cells with formulas 0
Excel Sumproduct 0
Excel Count If Formula Question 1
SUM / COUNT formula 3
Counting with Conditions but Only Once 8

Back
Top