Hi,

Are you sure these are really numbers in column A and not text that looks
like numbers. Try this in another columns and drag down for numbers it should
evaluate as TRUE

=isnumber(A4)

If you get FALSE put a 1 in a cell and copy it. Select your 'numbers' in
column A and then

Edit|Paste Special and slect Multiply.
OK

Now try your formula again.

Mike

"Jamakinmecrazy" wrote:

Hi,
I have tried using autosum to count the number of claims I have in 1 column
and it says 0 even when I have 55 claims in the column.
I have even tried entering =COUNT(A4:A55) and it still doesn't work.

If anyone can help I would greatly appreciate it.