Auto sum gives answer 0 when there are cell values


Ad

Advertisements

G

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
 
S

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)
 
D

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

Pete_UK

Ragu,

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

Pete
 
Ad

Advertisements

Joined
Sep 19, 2016
Messages
1
Reaction score
0
I do think that sharing a solution could be helpful for anyone needs to overwhelm a typical problem even after years, I was just searching the same problems, however all of the previous appreciated answers did not work with my case.
Hence, I'm confirming the simple following solution : Use the function (IMSUM), select the cells that you need their total summation, then click OK,
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top