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.

Try this:

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

HTH,

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


"ww" wrote in message
...
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.

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)


"RagDyeR" wrote in message
...
Try this:

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

HTH,

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


"ww" wrote in message
...
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.

Thanks to both of you, both ways worked great!

"Bob Phillips" wrote:

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)


"RagDyeR" wrote in message
...
Try this:

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

HTH,

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


"ww" wrote in message
...
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.