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