Is it text or numbers, if it is numbers you can use

=COUNTIF(E:E,"<"&99^99)

if it is text

=COUNTIF(E:E,"<="&REPT("z",253))


--


Regards,


Peo Sjoblom

"anji" wrote in message
...
I want in the excel sheet, to count the number of dated information cells
and omit #N/A cells with in one row