=SUMPRODUCT(--(A2:A10=""))+SUMPRODUCT(--(A2:A10="<"))



"Gaurav" wrote:

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?