I have =-ABS(R30:AC30) and is not converting the negative numbers to add as positive. I have a -70 and a -100 in there and need it to be 170.
I have =-ABS(R30:AC30) and is not converting the negative numbers to add as positive. I have a -70 and a -100 in there and need it to be 170.
Hello,
Try this instead.
=ABS(SUM((R30:AC30)))
=abs(sum(r30:ac30)) ?
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Perfect, thanks elayaz
Happy to help. Welcome
& Please mark this thread as [solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks