|Don't take this the wrong way, but do you read my posts in their entirety before you respond?|
Let me try this one more time:
For any that didn't return the correct result, please tell me what you expect the result to be and why - based on the contents of the cells.
Please keep in mind that I can not see your spreadsheet from where I'm sitting nor can I read your mind. If you don't tell why the results of the formula are wrong - based on the examples I used - I can't help you.
Let's look at what you asked for and then look at Table 2.
count all in G that is not = to LM where I iss = to Hired but only if E has something in it
E F G H I
5 Word LM Hired
6 Word Hired
7 Word LM Not Hired
8 Word Hired
9 Word LM Not Hired
count all in G that is not = to LM
- G6 & G8 are not equal to LM
I iss = to Hired
- I6 & I8 are equal to Hired
only if E has something in it
- E6 & E8 both have something in the cell.
I see that as 2 occurences that fit your 3 criteria.
Please tell me why the result should not be 2.