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

"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?

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?

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?

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?