View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Auto sum gives answer 0 when there are cell values

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

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 Thu, 14 Aug 2008 10:23:02 -0700, Coylumbridge
wrote: