One possibility is that the numbers in Column A are being recognized as
text. What do you get when you try...

=ISNUMBER(A2)

In article ,
ajajmannen
wrote:

I must say many thanks for all the help.....But It still counts it to 0
and I know that it should be around 700 entries at least.

Please help out.....I don't know what more information to give to be
able to get the correct formula.