Adding Positve and Negative Numbers

[Hunter]

Hi

I would appreciate it if anyone could advise on how I could add a column of positve and negative numbers, so that the end result is the value of the total of the absolute number?

-55
85
-52
=192

Thanks

 

[eliW]

Hunter,
Just enter:
=SUM(ABS(A1:A3))
Array enter by pressing ctrl+shift+enter
Eli

 

[Hunter]

Hi Eli

Thank you so much for your wonderful help. It works.

 

[IML]

A non-array solution would be
=SUMIF(A1:A3,">0")-SUMIF(A1:A3,"<0")

I would suggest going with eliW's answer as long you don't notice any performance issues (ie your have to use the formula many, many times)

 

[Hunter]

Hi IML

Thanks for your advice too. Your method works too and I would adopt your approach, as I do have some performance issues. I need to apply this formula across 10 columns actually.

Best regards
Hunter
This message was edited by Hunter on 2002-04-19 06:19

 

[Adcb]

Or :-

=SUM(A1:A3)-SUMIF(A1:A3,"<0")*2

 

[Hunter]

Hi Adcb

Thanks a lot.

Regards
Hunter