Formula - Sum only Positive Amounts but display as a Negative

[wadergirl]

I'm currently using this formula in cell B7 =SUMIF(A1:A7,">0") to sum only the positive amounts in my data set, but I need it as a NEGATIVE.
I know I could use =B7*-1 to turn that positive result into a negative, but I'm having trouble combining the two into a single formula.

This is what I'm trying to get to:

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]-2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]25
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]-8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]-8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: center"]-48[/TD]
[TD="align: center"]0
[/TD]
[/TR]
</tbody>[/TABLE]

There is no column C in my actual dataset, I've just added it above for illustration that the number in column B should be the opposite of the total in column A so that they net 0.

 

[t0azt]

Re: Formula Help - Sum only Positive Amounts but display as a Negative

Just put a minus sign in front of your formula.

=-SUMIF(A1:A7,">0")

 

[wadergirl]

Re: Formula Help - Sum only Positive Amounts but display as a Negative

Just put a minus sign in front of your formula.

=-SUMIF(A1:A7,">0")

Thank you. I'm such a moron. I actually just came back to delete this thread if I could, because I figured out =SUMIF(A1:A7,">0")*-1 also works. *headdesk*