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.
|