Adding in Multiple numbers, cont...

[ohnesorge]

It might be because my cells that io am trying to add have formulas?
My problem is that, when i use the sum formula, in which i did 1st it was
not adding correctly.
IE D8=0,E8=4,F8=(2),G8=(1) my sum formula is in O8 and it is showing 2, as
the answer. In my math the answer is 1???

 

[Luke M]

You're right it should be 1. Having formulas in the cells you are summing
should not make any difference.

First thing that comes to mind would be to check and make sure none of the
cells you are summing are formatted as text (as text values automatically = 0)

 

[Mike H]

Hi,

What answer do you see in the formula bar?
I would format all these formula answers and the formula cell as numbers
with a couple of decimal places and see if that throws any light on the
subject.

for example I can simulate your apparantly incorrect result with these values

answer
0.00 4.40 -1.50 -1.00 1.90

Which if formatted as numbers with no decimal places look like this

Answer
0 4 -2 -1 2


Mike