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

Question:

Question: 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

Reply

There’s more to the conversation

Read all replies

Page content loaded

Mar 15, 2018 11:56 AM in response to oopi In response to oopi

"Not elegant, but correct result."


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

User uploaded file

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

Reply Helpful
User profile for user: oopi

Question: sum up absolute values