adding in multiple numbers when on cell is Blank

[ohnesorge]

I am adding multiple cells in a row that contain negative numbers as well as
cells that have no value in them at all.
EXample: C1=3,C2=(1),C3=blank cell,C4=sum of numbers
Question= C4 is comming up with !value# because C3 is not filled in, how do
I fix?

 

[Mike H]

Hi,

=SUM(C1:C3) won't produce a value error with a blank cell in the range nor
will it do so if there is text. How are you summing these 'numbers' show us
the formula.

Mike

 

[Bob Phillips]

SUM should ignore blank cells.

 

[T. Valko]

Instead of doing it like this:

=C1+C2+C3

Do it like this:

=SUM(C1:C3)

Using the first approach will cause a #VALUE! error if any cells contain
text. Using the SUM function, it will ignore any text entries.

 

[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 O8and it is showing 2, as
the answer. In my math the answer is 1???

 

[T. Valko]

Make sure that any formatting you may be using is not "hiding" the true
result you're getting. Excel calculates based on the *true underlying value*
of a cell. You may have the cell formatted to *display* a certain way but
these are not the same.