Convert negative numbers to positive within an existing formula

dbarbella

New Member
Joined
Jun 6, 2017
Messages
32
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

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,167
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

New Member
Joined
Jun 6, 2017
Messages
32
Figured out a pretty simple solution by multiplying the formula by -1

But wonder if that's the smartest approach
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,139
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?
 

Forum statistics

Threads
1,085,718
Messages
5,385,450
Members
401,955
Latest member
Yendorian

Some videos you may like

This Week's Hot Topics

Top