Ignore error (#value)

**Jaspal** · 07-08-2013, 10:24 AM

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** · 07-08-2013, 10:30 AM

Hello
One way is the Sumif function, for example:

Please Login or Register  to view this content.

Hope this helps.
DBY

**Tony Valko** · 07-08-2013, 10:31 AM

One way...

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

If the cells are adjacent to each other:

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

**DBY** · 07-08-2013, 10:40 AM

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

Please Login or Register  to view this content.

DBY

Ignore error (#value)

LinkBack

Thread Tools

Rate This Thread

Display

Ignore error (#value)

Re: Ignore error (#value)

Re: Ignore error (#value)

Re: Ignore error (#value)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions