auto sum not working

[juster21]

i have 10 cells that i am trying to use auto sum on and the result is 0. it should be something besides 0....any ideas what is going on?

 

[Andrew Poulsom]

What's in the 10 cells?

 

[Joe4]

Are the values you are trying to SUM formatted as Numbers or Text? If they are Left Justified, that is probably a sign that they are entered as Text and not Numeric.

 

[juster21]

i have numbers in the cells. made sure the format was numeric....even multiplied the cells by 1 to make sure they were numeric. but my result is still showing as 0

 

[MOB]

Are your calculations definitely switched to automatic?

 

[juster21]

yep, automatic.

if i list 1, 2, 3, 4, 5 and at the 6 row use autosum the result is 0.
if i say =A1+A2+A3+A4+A5 and hit enter, the result is 0

 

[Joe4]

If you remove all justification on the cells, are the numbers Left or Right justified?

 

[juster21]

right justified

 

[Joe4]

What are the specific values in these cells?
They don't happen to add up to 0, do they (positives and negatives)?

If you use the function ISNUMBER on one of the cells, does it return TRUE?
i.e.
=ISNUMBER(A1)

 

[juster21]

no......number like 10, 250, 400, 9000.....nothing odd. it's just a count of completed tasks really