View Single Post
  #1   Report Post  
ww
 
Posts: n/a
Default Sum numbers that include #N/A

Hi all. I am trying to sum numbers from several columns.
An example might be

Col A Col B Col C Col D Col E
1 #N/A 5 8 #N/A

Is there a way to put a sum formula in column F that
would return 14 instead of #N/A. As extra information this
is an example I have quite a few more columns just figured
this might be enough information. Thanks for any help.