i was doing something wrong...it worked not
=COUNTIF($B$1:$B$9,"=")


"Gaurav" wrote in message
...
I have tried countif but it does not work.

so...if i have to count that in a column how many are there and how many
< are there...what function should be used?