Formula problem

[Guest]

I am entering a basic formula in my colum (=c41+c67) and it adds up to 0. It
should not as I have big amounts in the cells in question.

Please help

 

[Guest]

Are you sure C41 and C67 are numeric and not text?
If you have not changed the formating a quick way to check is to enter =
c41 in a cell. if the answer is left justified it is text and if right
justified is numeric.

or to enter =isnumber(C41)
a true answer indicates a number.

Another thing I have had happen is that if the values in c41 and C67 are
sufficiently below 0 and the cell in question if formated to sispaly no
decimal places it will show as 0.

there are multiple ways to get around the numbers as text problem. one
quick fix if you dont have to do it to often is to change your equation to
=value(c41)+value(c67)