adding in multiple numbers when on cell is Blank
 

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?

adding in multiple numbers when on cell is Blank
 

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

"ohnesorge" wrote:

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?

adding in multiple numbers when on cell is Blank
 

SUM should ignore blank cells.

--
__________________________________
HTH

Bob

"ohnesorge" wrote in message
...
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?

adding in multiple numbers when on cell is Blank
 

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.

--
Biff
Microsoft Excel MVP


"ohnesorge" wrote in message
...
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?

adding in multiple numbers when on cell is Blank
 

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.

--
Biff
Microsoft Excel MVP


"ohnesorge" wrote in message
...
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" wrote:

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.

--
Biff
Microsoft Excel MVP


"ohnesorge" wrote in message
...
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?