|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?