SUM negatives numbers as positive
 

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.

SUM negatives numbers as positive
 

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


"Susan" wrote:

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.