Hello,
I would like a formula that gives me the number of cells in a range that contain 2 words or more.
Preferably, I would also like to exclude from the count cells that contain a specific word/s.
Thanks!
Hello,
I would like a formula that gives me the number of cells in a range that contain 2 words or more.
Preferably, I would also like to exclude from the count cells that contain a specific word/s.
Thanks!
If the words are separated by space then, =countif(a2:A100,"* *")
Click the * to say thanks.
Thanks!
What about the second part of my question? How do I exclude (or subtract) cells that contain a specific word, for example the work "the"?
Haven't seen the second part. I guess that it would be something like: =countifs(a2:A100,"* *",a2:A100,"<>*the*")
Thanks so much!
You've been very helpful (and fast)!
I got some free time. And I'm glad to help. Please mark the Thread as Solved from Thread Tools.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks