Column SUM produces #N/A

I have a column using Vlookup to find values that I want to SUM.

Some of the look up values produce a #N/A and result in a total sum of #N/A.

How do I get the SUM of a column of numbers when all of the cell values are not in fact numbers.


Thanks

Jim O