Formula - Sum only Positive Amounts but display as a Negative

wadergirl

New Member
Joined
Jun 3, 2016
Messages
49
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-480

<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.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

t0azt

Board Regular
Joined
Aug 1, 2012
Messages
134
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

New Member
Joined
Jun 3, 2016
Messages
49
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*
 

Forum statistics

Threads
1,148,282
Messages
5,745,836
Members
423,981
Latest member
ph1l

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top