View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
杭州人 杭州人 is offline
external usenet poster
 
Posts: 4
Default ISERROR function

=SUM(IF(ISERROR(A1),0,A1),IF(ISERROR(A3),0,A3),IF( ISERROR(A6),0,A6))