sumif formula question ignoring #N/A

[tiny65]

I'm trying to create a sum using several columns, at the same time ignoring the #N/A reference in some cells. This is what I have and it does not error out, neither does it give me the result I'm looking for. Can anyone offer any assistance for me?

=SUMIF(C6:C23:G6:G23:J6:J23:O6:O23:R6:R23:U6:U23,"<> #N/A")

 

[T. Valko]

I'm trying to create a sum using several columns, at the same time ignoring the #N/A reference in some cells. This is what I have and it does not error out, neither does it give me the result I'm looking for. Can anyone offer any assistance for me?

=SUMIF(C6:C23:G6:G23:J6:J23:O6:O23:R6:R23:U6:U23,"<> #N/A")

No real elegant way to do that.

=SUMIF(C6:C23,"<1E100")+SUMIF(G6:G23,"<1E100")+SUMIF(J6:J23,"<1E100")+SUMIF(O6:O23,"<1E100")+SUMIF(R6:R23,"<1E100")+SUMIF(U6:U23,"<1E100")

 

[Joe4]

I would attack this another way.

Where are the #N/A's coming from? Are they the result of formulas?
If so, address the problem there using the ISNA function to correct those formulas.

For example, if you have a formula returning #N/A errors, change the formula to this in order to return 0 instead of the "#N/A" error.

=IF(ISNA(your formula here),0,your formula here)