When I sum up figures the answer is zero, what will I do?

  • Thread starter Thread starter May
  • Start date Start date
M

May

Please help me on my excel problem.

When I sum up all my figures the answer that comes out is 0; and when I copy
the sum formula of other cell the answer is the same as the figures from the
origin cell.

Is this something to do with cell formating?
 
May be the cells in the sum range are formatted as text..Try the below
workaround

Copy a blank cell. Keeping the copy select the sum range>Right click>Paste
Special>select Add>Hit OK to convert these cells to 'General' format. Now try
the sum formula on these cells

If this post helps click Yes
 

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

Similar Threads

Numbers showing Up Centered in Cell ? 1
sum only certain figures in the column 6
Error when using Sum command 3
How do I make this work? 15
How do I suppress a zero value or #VALUE! for a Pivot calculated i 9
Sum number range ignoring numbers formatted as text 0
Excel How to add numbers in same cell? 2
Rounding Up or Down to nearest $10 3

Back
Top