ExcelBanter - Suming 2 cells if 1 = #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Suming 2 cells if 1 = #N/A (https://www.excelbanter.com/excel-worksheet-functions/30209-suming-2-cells-if-1-%3D-n.html)

carl

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

Peo Sjoblom

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

Aladin Akyurek

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")

All times are GMT +1. The time now is 06:23 AM.