SOLVED

Excel COUNTIF part of cell

Copper Contributor

Hi everyone!

I am currently making an overview of certain studies and I want to calculate the amount of time a certain intervention is mentioned.

So my cells are, for example, filled with the word "acceleration" or "enrichment", however, sometimes both get mentioned, so a cell says "acceleration ; enrichment". 

I used COUNTIF "acceleration" for my formula, but that only counts the amount of times a cell only mentions acceleration. What can I change in order to have the combined cells to be included too?

 

Thank you very much!

2 Replies
best response confirmed by jessicav (Copper Contributor)
Solution

@jessicav 

You can use wildcards in the condition:

 

=COUNTIF(range, "*acceleration*")

That's great, thank you very much!
1 best response

Accepted Solutions
best response confirmed by jessicav (Copper Contributor)
Solution

@jessicav 

You can use wildcards in the condition:

 

=COUNTIF(range, "*acceleration*")

View solution in original post