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

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


Jackh


--
jackh

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

Hi Jack

Try
=SUMIF(A:A,"<#N/A")

Regards

Roger Govier


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


Jackh

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

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