If you want greater than 4 it is =COUNTA($C$11:$C$15)4
If you want greater than or equal to 4 it is =COUNTA($C$11:$C$15)=4
--
David Biddulph

"offdah3z" wrote in message
...
One more question, how can I that to be greater than 4? I've tried a
million
things.

=COUNTA($C$11:$C$15)=4

for some reason, Excel hates that, and thats the most logical thing I've
tried. i'm embarrassed to show the rest.
....