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.


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:


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 •

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

Report •

March 25, 2011 at 16:23:26

Report •

Related Solutions

Ask Question