Combination of CountIF, IF, and NOT

I am helping someone at my work to do some formula on evaluation -

For example -

There are three evaluators on one subject. Each of them evaluate with those following letters - S, U, I.

Now we need to "average" those ratings - Such as -

S, S, S = S
S, S, I = S
S, I, I = I
U, S, I = I
I, I, I = I
I, I, U = I
I, U, U = U
U, U, U = U

Need to reevaluate =
S, S, U
S, U, U

So the first part is very easy = the formula goes -
=IF(COUNTIF(D10:I10,"S")>=2,"S",IF(COUNTIF(D10:I10,"I")>=2,"I",IF(COUNTIF(D10:I10,"U")>=2,"U")))

But when I tried to add NOT "U" in the first part (S, S, U) basically, if there is an U with two S, then that category needs to be reevaluate. I couldn't get that to work. As for U as well - if there are two Us, but with one S, then it needs to be re evaluate.

I'd appreciate if you are able to assist with this formula It is the LAST one that we need to figure.

Shannon

I am working with MS Excel 2010.

I'm not worrying about valid letters - but to indicate if this category needs to be reevaluate

For example -

Evaluator #1 = S (satisfactory)
Evaluator #2 - I (Need improvement)
Evaluator #3 - U (Unsatisfactory)

Now -
One catergory - Turn=Taking Mechanism -

the results are -
S, S, U (this is invalid due to a huge difference between those two rates - the raters need to meet together and discuss why one feels that the testee did not do a good job in that area). So the results need to come out as "Need to Reevaluate"

If it is S, S, I, it will come out as S (which I accomplished)

The only two possibles that requires the results = "Need to Reevaluate" are:
S, S, U
S, U, U

In my formula, if there is 2 or more Us, the rate will be U. But not if it has S, if so, then it needs to be re evaluate.

I hope my question is clear? If you need the file, i will send it to you.

Shannon

It works!!!! (the regular code). I need to understand how it works, but at least it works so I can give the file back to the person who are doing evaluations next week.

Shannon