countif 1 of 3 choices (or)

Microsoft Exchange server 2007 x64 dvd -...
March 25, 2011 at 15:24:42
Specs: Windows XP
If I use the formula below and all three are listed in the cell, the count equals 3.

=countif(J34,("*oji*","*duty*","*light*"))

How can I get it to count only one of the three? All three mean the same thing, but sometimes people will type in more than one in the comment. e.g. "oji - on light duty"

I'm trying to combine an "or" with the countif:

=COUNTIF(or(J34,"*oji*"),(J34,"*duty*"),(J34,"*light*"))

Is the syntax wrong? or can you not use the "or" with countif? or is there a better way?


See More: countif 1 of 3 choices (or)

Report •

#1
March 25, 2011 at 15:33:06
Try asking your question in the proper forum.

Report •

#2
March 25, 2011 at 16:23:26

Report •
Related Solutions


Ask Question