LinkBack URL
About LinkBacks
Togaman7 
Is there a way to get an absolute value for the sum of 1 column that has both positive and negative numbers?
Is there a way to get an absolute value for the sum of 1 column that has both positive and negative numbers?
Your question can be interpreted more than one way.
With pos/neg values in A2:A10
This formula converts each to positive...then sums them
This formula sums the values...then returns the absolute value of the sum
=SUMPRODUCT(ABS(A2:A10))
Is that something you can work with?=ABS(SUM(A2:A10))
Thanks Ron. It was the first option I was looking for. Much appreciated.
I agree. Thank you Ron for that first option. I didn't know you could use Sumproduct that way. You have saved me from making unnecessary extra columns in the future.
=ABS(SUM(A1:A50)) will give you an absolute value. I put in 1 and -5 and it will give me 4 even though the sum is really -4.
If you want the absolute value of each individual number then you will probably have to make another column and do =ABS(A1) and drag it down the whole column and then sum that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks