One fix would be to trap the errors rather than leaving them in your
worksheet. Instead of

=VLOOKUP(A1,J:K,2,FALSE)

you can use

=IF(ISNA(MATCH(A1,J:J,FALSE)),"Not Found",VLOOKUP(A1,J:K,2,FALSE))

In article ,
jackh wrote:

I have a column containing numbers as well as #N/A (result of a Vlookup
formula). How do I sum the column to return the total of all numerical
values