Hi,

And yet another way which may seem more intuitive:

=SUMIF(A1:C1,"<#DIV/0!")

In the case of tm's formula the idea is to make the second argument larger
than anything in the range, so if you know you number will be smaller than
9,000,000,000 you can use:

=SUMIF(A1:C1,"<9E9")

or if you know the largest number will be 8 you could use

=SUMIF(A1:C1,"<9")

and so on.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Amanda" wrote:

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!