=IF(ISNA(your formula),0,your formula)


"Steve" wrote:

I am using a vlookup finction, and when it doesn't find a record it
returns an N/A error. Is there any way to remove the N/A error in the
formula so I can sum the returned data? Thanks.