Sum of absolute values in a range with #n/a also in the range

[Mark McInerney]

I ahve a range of cells containing postive and negative numbers, and the range also has some #n/a values. I want need a formula that will give me the sum of the absolute values in this range. I',ve tried sumproduct(abs(range)) which will only work if there are no #n/a values.

Is there a way of incorporating a sumif statement somewhere?

Thanks in advance - Mark.

 

[Jonmo1]

Try

=SUMIF(A1:A100,">0")-SUMIF(A1:A100,"<0")

 

[Mark McInerney]

Genius Jonmo1 - Many Thanks - Appreciated!

 

[Jonmo1]

Glad to help, thanks for the feedback.