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