AutoSum not working on numeric data

[Mariners]

I have a column formatted as a number, no decimals, with a ','. This data has been exported as Xls 8.0 Extended from a 3rd party application. I can manually enter a formula and I get correct results for =A2+A22, but when trying to use AutoSum it simply comes up =SUM() and not =SUM(A2:A22).

 

[shades]

I can manually enter a formula and I get correct results for =A2+A22, not =SUM(A2:A22).

These two formulas are not equivalent, but your question makes it appear as if you mean that they are. Can you clarify?

Probably there are blank cells somewhere in the range, and if so the AutoSum will not know which you want. Once you click the AutoSum button, then click on A2, hold donw the CTRL key and click on A22, then hit RETURN. That will give you what you write is "the correct result".

When you click on the cell the formula will look like this:

=SUM(A2,A22)
________
Gm le8 engine specifications

 

[Mariners]

I didn't mean to infer the two formulas were equivalent, it was an example of one method working and the other method not working.

A coworker found the solution on Microsoft web site, used Google to locate, the Microsoft site is difficult to locate information.

There are several different ways to fix the problem.

http://support.microsoft.com/kb/291047

Thanks!