I am trying to generate a count if a particular cell contains the text "*Microsoft Word*" OR "*.doc*". I am using this formula in the attached spreadsheet at M2:
=COUNTIF(E2,"*Microsoft Word*")+COUNTIF(E2,"*.doc*")
The problem is that when I use that formula, it returns a value of 2. I only want it to count once if it sees either of those parameters ("Microsoft Word" or ".doc"), not both. Therefore the value returned should be 1.
Any help would be greatly appreciated!
Bookmarks