View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ragu Binu Ragu Binu is offline
external usenet poster
 
Posts: 1
Default Firstly get rid of the unnecessary SUM() function.

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 1:23 PM Coylumbridg wrote:





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 SpecialAddOKEsc.


Gord Dibben MS Excel MVP



On Wednesday, November 12, 2008 10:22 AM Skaraba wrote:


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 $0
=SUM(J127+J125+J123+J121+J111+J109+J107+J105+J103+ J101+J99+J97+J91+J89+J64+J58+J26+J24+J22+J20+J18+J 16+J11+J9+J7)

"Gord Dibben" wrote:



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+J 16+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+J 11+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.
--
David Biddulph

"Skarabat" wrote in message
...