try the following:
=if(iserror(vlookup(...))," ",vlookup(...))

this will replace missing values where you are currently getting #N/A and
your sum will work

"Russell Johnson" wrote:

I am trying to create an inventory list that is blank unless someone enters
in an item number which would then use Vlookup to fill in all of the
pertinent information such as description, price, unit of measurement,
etc....it all works great until I try to sum it all up at the end to get a
total dollar amount and the notorious #N/A screws up my SUM even if there is
only one #N/A left unchanged.

Is there a way for the SUM to ignore the #N/A? Maybe an IF.THEN statement
in the row subtotal? Any suggestions?