How to COUNTIF with multiple criteria
I have formulas in my sheet to count the number of times a specific word is in a specific column. I need to count two words now without counting the cell twice if the word is in both. How do I write a formula for this?
I am looking for something like this: COUNTIF the column CONTAINS "word1" OR "word2", @cell.
The problem I am running into is I don't want to count the cell twice if it contains both words.
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!