adding in multiple numbers when on cell is Blank

  • Thread starter Thread starter ohnesorge
  • Start date Start date
O

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?
 
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
 
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.
 
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???
 
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.
 
Back
Top