Mar 31 2021 05:20 AM
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!
Mar 31 2021 05:41 AM
SolutionMar 31 2021 05:41 AM
SolutionYou can use wildcards in the condition:
=COUNTIF(range, "*acceleration*")