SUM negatives numbers as positive

[Guest]

The range of numbers in a SUM formula includes some negative values, but I
would like the negative values included in the SUM as positives. I need the
negative values in the range to stay displayed as negatives.

 

[Guest]

You can use the ABS function to return the absolute value of a number. So,
something like this:

=SUM(ABS(A1:A100))

This is an Array formula and must be entered with CTRL-SHIFT-ENTER instead
of just Enter. If done properly, the formula should be enclosed in { }.

HTH,
Elkar