AutoSum errors

[Dave]

I have been looking for something to resolve an Autosum
formula error. If I add each cell individually, the
numbers added are correct. But if I use the Autosum
formula function, the numbers are off by some 37,000. I
have made sure that all the numbers are in the same 2-
digit format, and there are no floating point errors. I
have removed cells that might be empty, and still the
numbers are off by the same amount. I have also double
checked the range to be sure that only the numbers I want
added are included and nothing else.

Is there something about using the Autosum function that
I missed somewhere? Please e-mail me at
(e-mail address removed), or post something here.

 

[Debra Dalgleish]

Some of cells may contain numbers that are being treated as text. To fix
these, use one of the techniques shown here:

http://www.contextures.com/xlDataEntry03.html

 

[RagDyer]

Some of your numbers could be text that just look like numbers.

Try using
=ISNUMBER(A1)
for example, with your pertinant cells replacing "A1", and see if you get
any "FALSE" returns.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have been looking for something to resolve an Autosum
formula error. If I add each cell individually, the
numbers added are correct. But if I use the Autosum
formula function, the numbers are off by some 37,000. I
have made sure that all the numbers are in the same 2-
digit format, and there are no floating point errors. I
have removed cells that might be empty, and still the
numbers are off by the same amount. I have also double
checked the range to be sure that only the numbers I want
added are included and nothing else.

Is there something about using the Autosum function that
I missed somewhere? Please e-mail me at
(e-mail address removed), or post something here.