I have VLOOKUPs that return the value #N/A on occasion, as a matter or
course. I SUM those values. Currently I copy/paste values on the results,
then sort out and delete the #N/As to make the SUM work.

Is there a better way?

Can you alter the SUM sytax to force it to skip over #N/As?
Or can you imbed an IF/THEN statement arount the VLOOKUP to display #N/As as
zero?