Sum numbers that include #N/A

[Guest]

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.

 

[RagDyeR]

Try this:

=SUMIF(A1:E1,"<>#N/A")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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.

 

[Bob Phillips]

Another way

=SUM(IF(NOT(ISNA(A1:E1)),A1:E1))

which is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks to both of you, both ways worked great!

Another way

=SUM(IF(NOT(ISNA(A1:E1)),A1:E1))

which is an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)