If functions and count if functions

[enoch0909]

This is the formula that i have right now. =If(COUNTIF(M2:W2<6),"Rejected","Accepted") I can't seem to get it can anyone help me. What i am looking for is a formula that counts a range of cells that have numbers ranging from 1-10. Is there a way to have if m2:w2 is less than six to say it is rejected and if it is more than or equal to 6 it will accept it.
A1 M2 N2 O2 P2 Q2 R2 S2 T2 U2 V2 W2

Rejected 8 9 10 7 6 9 5 8 8 9 6
Accepted 10 9 10 9 7 9 8 10 9 8 8

 

[enoch0909]

This is the formula that i have right now. =If(COUNTIF(M2:W2<6),"Rejected","Accepted") I can't seem to get it can anyone help me. What i am looking for is a formula that counts a range of cells that have numbers ranging from 1-10. Is there a way to have if m2:w2 is less than six to say it is rejected and if it is more than or equal to 6 it will accept it.
A1 .............M2.. N2.. O2.. P2.. Q2.. R2.. S2.. T2.. U2.. V2.. W2..

Rejected .....8..... 9 .....10....7.....6.......9.....5.....8.......8......9......6
Accepted 10........9......10....9.....7.......9.....8....10......9......8......8

 

[Eric W]

Try:

=IF(COUNTIF(M2:W2,"<6"),"Rejected","Accepted")

This will show Rejected if there are any values less than 6, otherwise Accepted.

 

[enoch0909]

Ty

 

[Eric W]

You're welcome.

 

[AhoyNC]

Try:

[TABLE]
<colgroup><col width="380"></colgroup><tbody>[TR]
   [TD="width: 380"]=IF(COUNTIF(M2:W2,[COLOR=#ff0000]"<6"[/COLOR]),"Reject","Accepted")
[/TD]
 [/TR]
</tbody>[/TABLE]