Sum with Errors

[dgoodrid]

All,

can someone help me please. can someone advise me how to add the following information up.

I need to ADD the numbers listed below but if a cell value = #N/A then the result = #N/A

Example 1
----------

2 4 4 "=sum(A1:A3)" - 10

2 #N/A 4 "=sum(A1:A3)" - #N/A

Any advise, I cant stop the errors in the cells as they are looking for info in a Vlookup table and there is no data found.


Dave

[sven137]

I too am looking for a solution. We need something in the formula to tell it to ignore non-numerical or ISERROR value. Something about If(AND(ISNUMBER.... but that is as far as I've got.

sven

[sven137]

Hi, I found a solution to ignore the error fields so that the sum function works.

My sum total is in column 3 & my lookup values are in column 2.
=IF(ISERROR(C2),0,C2)

This is stating that if the cell ISERORR due to being blank or value error in the lookup then fill field with 0, if the field is not blank then use the value found in the cell. I hope this helps you.

cheers
Sven