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?