Hello, everyone.
I have to look for a select group of words in a range of cells. Some cells contain more than one of the words that I am looking for. I need a function that will count the cells that contain the specific words without double counting the cells that contain more than one of the words.
Which function can I use to do this? I do not know how to add a condition to the countif function that will prevent it from counting twice (or thrice) the cells that contain more than one of the specific words.
Any and all help is appreciated.
Bookmarks