Thread: sum, except #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
  
Posts: 468
Default sum, except #N/A
Hi, i have this code : =SUMPRODUCT(--SUBSTITUTE(C4:AA4,"Late ",""))
In some cells i have #N/A , and the code it's not working anymore. I need
the code to sum everything but to ignore #N/A.
Can this be done?
Thanks!
Reply With QuoteReply With Quote