Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

# Question:Q:sum up absolute values

Hi

How can I sum up absolute values of a column?

Thanks for any hint!

Mac mini (Late 2014), macOS High Sierra (10.13.3)

Posted on

I think the easiest is to think of it as subtracting the negatives, which turns them positive....

e.g. =SUMIF(A2:A11,">0") - SUMIF(A2:A11,"<0")

Jason

There’s more to the conversation

I think the easiest is to think of it as subtracting the negatives, which turns them positive....

e.g. =SUMIF(A2:A11,">0") - SUMIF(A2:A11,"<0")

Jason

Mar 15, 2018 9:49 AM

"Not elegant, but correct result."

If 'elegant' means 'neat and well-dressed' and applies only to appearance, this might fit the description.

In the same manner as the elegance of a swan gliding swiftly across the pond, though, the calm and serene appearance belies the furious paddling going on below the surface.

Here, the first stage is carried out by the formula below, entered in C2 and filled down to C10.

C2: ABS(B2)

Regards,

Barry

Mar 15, 2018 11:56 AM

User profile for user: oopi

Question: sum up absolute values