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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Togaman7 
Register To Reply
Bookmarks