Auto sum gives answer 0 when there are cell values

[Gord Dibben]

Could be the values you see are formatted as Text

Re-format all to General

Copy an empty cell.

Select the range of values and Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP

 

[Skarabat]

I am having this problem as well. I made sure that the autocalculation was
chosen in the tools. When I enter this line it will not total the numbers -
I just get $
=SUM(J127+J125+J123+J121+J111+J109+J107+J105+J103+J101+J99+J97+J91+J89+J64+J58+J26+J24+J22+J20+J18+J16+J11+J9+J7)

 

[David Biddulph]

Firstly get rid of the unnecessary SUM() function.
=SUM(J127+J125+J123+J121+J111+J109+J107+J105+J103+J101+J99+J97+J91+J89+J64+J58+J26+J24+J22+J20+J18+J16+J11+J9+J7)
can be replaced by
=J127+J125+J123+J121+J111+J109+J107+J105+J103+J101+J99+J97+J91+J89+J64+J58+J26+J24+J22+J20+J18+J16+J11+J9+J7

Secondly, did you try the solution which Gord suggested?

The chances are that your data cells contain text not numbers. After you've
tried Gord's solution, if you're still getting a zero result, look at
=ISNUMBER(J127) and =ISTEXT(J127), [for a cell where you think you've got a
non-zero value.]
If you've still got text you may need to look for non-printing characters in
the cell.

 

[Ragu Binu]

Check the cell value it might be stored as "numbers stored as Text" change that to "Convert to Numbers" by clicking the dialouge box or else you format the entire row or column in numbers and then re enter the value of each cell and then do autosumation you will get the correct answer..

hoe it will be usefull....

Ragu.....

On Thursday, August 14, 2008 2:23 PM Gord Dibben wrote:
Could be the values you see are formatted as Text

Re-format all to General

Copy an empty cell.

Select the range of values and Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP

On Wednesday, November 12, 2008 11:13 AM David Biddulph wrote:
Firstly get rid of the unnecessary SUM() function.
=SUM(J127+J125+J123+J121+J111+J109+J107+J105+J103+J101+J99+J97+J91+J89+J64+J58+J26+J24+J22+J20+J18+J16+J11+J9+J7)
can be replaced by
=J127+J125+J123+J121+J111+J109+J107+J105+J103+J101+J99+J97+J91+J89+J64+J58+J26+J24+J22+J20+J18+J16+J11+J9+J7

Secondly, did you try the solution which Gord suggested?

The chances are that your data cells contain text not numbers. After you've
tried Gord's solution, if you're still getting a zero result, look at
=ISNUMBER(J127) and =ISTEXT(J127), [for a cell where you think you've got a
non-zero value.]
If you've still got text you may need to look for non-printing characters in
the cell.

 

[Pete_UK]

Ragu,

Is it really necessary to respond to a post that is nearly three years
old?

Pete