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

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

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

Sorry, works fine for me. All I can suggest is to edit each number (F2) and
make sure that the format takes okay.

--
HTH

Bob Phillips

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

"Alectrical" wrote in message
...
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

Some of your numbers may actually be text.

Re-formatting alone does not do the trick.

Format all to General.

Copy an empty cell.

Select numbers and Paste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Fri, 11 Aug 2006 02:04:01 -0700, Alectrical
wrote:

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