Suming 2 cells if 1 = #N/A

Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
#N/A ?

Thank you in advance

try
=if(iserror(A1),0,A1)+if(iserror(B1),0,B1)

"carl" wrote:

> Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> #N/A ?
>
> Thank you in advance

try
=if(iserror(A1),0,A1)+if(iserror(B1),0,B1)

"carl" wrote:

> Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> #N/A ?
>
> Thank you in advance

Or maybe even

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

of course the cells have to be adjoining


Regards,

Peo Sjoblom

"bj" wrote:

> try
> =if(iserror(A1),0,A1)+if(iserror(B1),0,B1)
>
> "carl" wrote:
>
> > Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> > #N/A ?
> >
> > Thank you in advance

Or maybe even

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

of course the cells have to be adjoining


Regards,

Peo Sjoblom

"bj" wrote:

> try
> =if(iserror(A1),0,A1)+if(iserror(B1),0,B1)
>
> "carl" wrote:
>
> > Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> > #N/A ?
> >
> > Thank you in advance

Or maybe even

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

of course the cells have to be adjoining


Regards,

Peo Sjoblom

"bj" wrote:

> try
> =if(iserror(A1),0,A1)+if(iserror(B1),0,B1)
>
> "carl" wrote:
>
> > Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> > #N/A ?
> >
> > Thank you in advance

carl wrote:
> Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> #N/A ?
>
> Thank you in advance

=SUMIF(A2:B2,"<>#N/A")

carl wrote:
> Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> #N/A ?
>
> Thank you in advance

=SUMIF(A2:B2,"<>#N/A")

try
=if(iserror(A1),0,A1)+if(iserror(B1),0,B1)

"carl" wrote:

> Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> #N/A ?
>
> Thank you in advance

carl wrote:
> Is there a way to sum 2 cells but if one of the cells is #N/A, to ignore the
> #N/A ?
>
> Thank you in advance

=SUMIF(A2:B2,"<>#N/A")