SUMIF excluding #N/A
 

I am trying to add different cells located in different worksheets (tabs)
within the same workbook. I know I can use =SUMIF(A1:A5,€�<#N/A€�) without
error.

The problem I am having is trying to add different cells not grouped
together while using SUMIF. Example, =SUMIF(A1+A3+B5+C20, €�<#N/A€�). If B5
=#N/A for instance, then my SUMIF will not work.

Any solutions?

Thank you in advance for help.

SUMIF excluding #N/A
 

My solution would be to get rid of the #N/As. For example, if they're a
result of a Vlookup, use If to check for it, as in:
=if(isna(vlookup(...)),0,vlookup(...))

Regards,
Fred.

"Scott A" wrote in message
...
I am trying to add different cells located in different worksheets (tabs)
within the same workbook. I know I can use =SUMIF(A1:A5,€�<#N/A€�) without
error.

The problem I am having is trying to add different cells not grouped
together while using SUMIF. Example, =SUMIF(A1+A3+B5+C20, €�<#N/A€�). If
B5
=#N/A for instance, then my SUMIF will not work.

Any solutions?

Thank you in advance for help.