"Amanda" wrote:
I have a problem to add numbers with cells that has error.
Any advice what can be done?

First, avoid the #DIV/0 error. Use one of the following formulas, based on
your preference:

=if(C2=0,"",C1/C2)

=if(C2=0,0,C1/C2)

I am assuming that the rows labeled "a" and "b" are rows 1 and 2.

Second, if you choose the first formula, compute the sum with SUM(A3,B3,C3)
instead A3+B3+C3, which would result in a #VALUE error because of the ""
text.

PS: In the future, it would be easier if you posted examples with actual
Excel row and column references instead abstract names like "a", "b" and
"a/b". "SUM A+B+C" is particular misleading.


----- original message -----

"Amanda" wrote in message
...
I have a problem to add numbers with cells that has error. Any advice what
can be done? Thanks

A B C
a 5 5 5
b 1 1 0
a/b 5 5 #DIV/0! SUM A+B+C #DIV/0!