Hi Mike,
An easy way around this is to change the formula slightly. Instead of the
error trap inserting a "", use 0 (zero) instead. It will keep your SUM
function happy.

=IF(ISERROR(VLOOKUP(A6,H7:M121,3,FALSE)),0,VLOOKUP (A6,H7:M121,3,FALSE))

Regards - Dave.