Hi Steve

=IF(COUNTIF(B1:H1,"C")=5,"OK,"Alert")

--
Regards
Roger Govier

"Steve" wrote in message
...
I have various codes(letters) in cells B1 thru N1.(see below)
If B1:H1 has 5 or more C's , I want "OK", if not "Alert". In this case, it
would be "alert' because only 4 C's.
Also if H1:N1 the same. This scenario would be "OK", because it has 5 C's
in
that range. Something like the below:
If(B1:H1("[[[has 5 or more C's]]]","OK","Alert")

B C D E F G H I J K L M N
s c c ns c ns c c c ns c ns c

Thanks,

Steve