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
 
Back
Top