SOLVED

Excel COUNTIF part of cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2246836%22%20slang%3D%22en-US%22%3EExcel%20COUNTIF%20part%20of%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246836%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone!%3C%2FP%3E%3CP%3EI%20am%20currently%20making%20an%20overview%20of%20certain%20studies%20and%20I%20want%20to%20calculate%20the%20amount%20of%20time%20a%20certain%20intervention%20is%20mentioned.%3C%2FP%3E%3CP%3ESo%20my%20cells%20are%2C%20for%20example%2C%20filled%20with%20the%20word%20%22acceleration%22%20or%20%22enrichment%22%2C%20however%2C%20sometimes%20both%20get%20mentioned%2C%20so%20a%20cell%20says%20%22acceleration%20%3B%20enrichment%22.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20used%20COUNTIF%20%22acceleration%22%20for%20my%20formula%2C%20but%20that%20only%20counts%20the%20amount%20of%20times%20a%20cell%20only%20mentions%20acceleration.%20What%20can%20I%20change%20in%20order%20to%20have%20the%20combined%20cells%20to%20be%20included%20too%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2246836%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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 (New Contributor)
Solution

@jessicav 

You can use wildcards in the condition:

 

=COUNTIF(range, "*acceleration*")

That's great, thank you very much!