Thanks:  0
Likes:  0

1. 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

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

3. Hi Eli

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

4. 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)

5. 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 ]

6. Or :-

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

Thanks a lot.

Regards
Hunter

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•