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:

5
-2
25
-8
-8
5
13	-48	0

<tbody>
</tbody>

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*