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

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?
 
J

Jacob Skaria

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

sum only certain figures in the column 6
A SUM FUNCTION (EXCEL) RETURNS A ZERO VALUE BUT DISPLAY IN (0.00), 2
Making a cell equal to Zero 5
How do I 'SUM' a column corrected to 2 decimal places from 3 2
my formulas return a zero 3
Numbers showing Up Centered in Cell ? 1
Formula Needed : Sum on Conditions 3
how do I sum year to date tables 4

Top