Try this:

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

--
Biff
Microsoft Excel MVP


"Excel0247" wrote in message
...
Hi,

How do I use the sum function on a column where I have used Vlookup and
#N/A appears - the sum function will not total the dollar amounts.

Is there a work around or formula change available ?

Thanks for your help