Return Positive Value of SUMIF

[jmattingly85]

I am using the following sumif formula:

=sumif(U5:U91,"2",N5:N91)

N5:N91 contains all negative numbers, and I need to make them positive. How can I accomplish this?

Thank you!

 

[Trebor76]

Hi jmattingly85,

Try this:

=ABS(SUMIF(U5:U91,"2",N5:N91))

Regards,

Robert

 

[gravanoc]

Another neat trick is to put a - in front of your Sumif. So =-SUMIF(U5:U91, "2", N5:N91)

 

[Trebor76]

Another neat trick is to put a - in front of your Sumif. So =-SUMIF(U5:U91, "2", N5:N91)

Or:

=SUMIF(U5:U91,"2",N5:N91)*-1

Note though that these will reverse the total so if it happens to be positive it will return a negative. Depends what the OP really wants I suppose.