Hi
change your formula to
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

"Martin" wrote:

Hello, my vlookup is returning n/a values which is ok. I still want the
column to add the totals of the vlookups but at the moment the total cell is
showing n/a because some of the vlookups are returning n/a values. Can I
still get a total sum of the column even though some of the vlookups are
showing n/a