3

I have a column of numbers and would like to know the total after everybody has paid me back, but I have negative numbers currently in there:

column example

So the total of this should be 95, currently if I do a sum it will be 75.

This is what I currently have:

=SUM(IF(B2:B27<0,-1*B2:B27,B2:B27))

but this doesn't work of course as it does it on the total of all the rows within the range in the column.

3

Please try:

=ArrayFormula(sum(abs(B2:B27)))

ABS

(For an answer of 105 if all the numbers displayed fall into the range (and no others).)

  • Wowza sir... You have skills with sheets :) – Jamie Hutber Nov 14 '17 at 14:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.