Using COUNTIF with OR in googledocs
I have a column with varius text inputs. I'd like to count the number of
cells that include either "word1" or "word2". So that if a single cell
contains one or more of these it counts as one.
I've managed to make a formula that I think counts all occurences of
"word1" and "word2", but I'm only after the amount of cells containing one
of them (or any number of them).
Can anyone help?
Thanks!
No comments:
Post a Comment