Convert negative numbers to positive within an existing formula

[dbarbella]

Hi All,

I'm summing a total value, which I know will always be a negative number.
Trying to avoid hidden helper cells if possible

The current formula is:
=SUMIFS('Advance Bill Rec'!T$3:T$2000,'Advance Bill Rec'!K$3:K$2000,D21,'Advance Bill Rec'!U$3:U$2000,">=" & $I$1,'Advance Bill Rec'!U$3:U$2000,"<=" & $J$1)

Was wondering if there was a simple wrapper type of function to convert the negative number to a postive

Thanks Much
-D

 

[Eric W]

You could just put a minus sign at the front, or use ABS(). If you think some of the rows are positive and some negative, and you want to sum the absolute values, you'd need to use SUMPRODUCT.

 

[dbarbella]

Figured out a pretty simple solution by multiplying the formula by -1

But wonder if that's the smartest approach

 

[Aladin Akyurek]

If the formula always returns a negative sum and you want it to a positive result, negate that result...

=-SUMIFS('Advance Bill Rec'!T$3:T$2000,'Advance Bill Rec'!K$3:K$2000,D21,'Advance Bill Rec'!U$3:U$2000,">=" & $I$1,'Advance Bill Rec'!U$3:U$2000,"<=" & $J$1)

Is this what you meant?

 

[dbarbella]

Thanks Much Eric
-D