sum a column containing numbers as well as #N/A

J

jackh

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


Jack
 
J

JE McGimpsey

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))
 
Top