View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Troy[_2_] Troy[_2_] is offline
external usenet poster
 
Posts: 18
Default sum of cells that may contain #n/a

If I am summing cells that may or may not contain an error (#n/a) is there a
way to ignore these cells? Or replace (#n/a) with a zero?