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

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?

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

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 rangeRight clickPaste
Specialselect AddHit OK to convert these cells to 'General' format. Now try
the sum formula on these cells

If this post helps click Yes
---------------
Jacob Skaria


"May" wrote:

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?