AutoSum

[Alectrical]

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

 

[Bob Phillips]

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]

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]

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)

 

[Gord Dibben]

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 Special>Add>OK>Esc.


Gord Dibben MS Excel MVP