Thread: Remove errors
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve[_4_] Steve[_4_] is offline
external usenet poster
 
Posts: 184
Default Remove errors

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.