Formula - Sum only Positive Amounts but display as a Negative

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

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
Re: Formula Help - Sum only Positive Amounts but display as a Negative

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

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

=-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*

Replies
3
Views
157
Replies
4
Views
123
Replies
1
Views
793
Replies
1
Views
148
Replies
5
Views
218

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.

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

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