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