hi,

you can imbed in the if by using the iserror function, so you would
have =IF(ISERROR(A1),0,A1) for example.

let me know if have any problems

Looking-for-a-brainiac wrote:
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?