one way might be
=SUM(IF(NOT(ISNA(Range)),Range))
array entered (control/shift/enter)

This may not be the most efficient way of dealing with it.
Perhaps a better alternative is to avoid the #N/A results by using an if
statement in the VLookup
or a separate column that simply tests the principal column for #N/A and
then sum that.
Not sure what would cause the least system overhead.

--
Return email address is not as DEEP as it appears
"sa" wrote in message
...
I have a range of cells that utilizes the VLOOKUP command to search for
numerical data by descrition and place it in a cell. Then I want to add
the
numerical data with the sum function. But in some cells there is #N/A
because
the numerical data isn't present. The Sum function always returns #N/A
when
this occurs.

Can anyone help with this?