No there are no blank cells, for example AutoSum stop calculating at 5.5 in
the following sequence of numbers.

4
4
4
4
4
4
5.5
9
22
180


"Bob Phillips" wrote:

Do you have blank cells, Autosum goes to the blanks and stops there.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alectrical" wrote in message
...
Hi

When I highlight a range of cells AutoSum misses certain cells, even
though
all cells have the same format. The same applies when I change the format
to
General, Number or Text.

Any Ideas.

Thanks
Alec