Hi,

COUNT counts the number of numbers in a range
COUNTA counts the number of non-empty cells in a range

You can also use COUNTIF or COUNTIFS (if you are using 2007)
=COUNTIF(A4:A55,"<")

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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.