Ignore error (#value)

[Jaspal]

I am trying to add two cells together.

If one of the cell has an error (#value) how would i get the formula to attribute a 0 value to this cell.

Thanks

[DBY]

Hello
One way is the Sumif function, for example:

=SUMIF(A2:A3,"<>#VALUE!",A2:A3)

Hope this helps.
DBY

[Tony Valko]

One way...

=IF(COUNT(A1),A1)+IF(COUNT(A10),A10)

If the cells are adjacent to each other:

=SUMIF(A1:A2,"<1E100")

[DBY]

Just to add a note to my first post. As Tony shows the final range in Sumif is optional, so:

=SUMIF(A2:A3,"<>#VALUE!")

DBY