SUMIF Positive, then Negative numbers at each Group change

[JLopez123]

Hello all

Racking my brain trying to create an Excel formula that gets the outputs on the two right columns.

I want column C to only SUM the positive numbers within each Group under Column A, otherwise populate a $0 if it runs into a negative value. Then column D would be the inverse - SUM all Negatives within each Group, but then populate a $0 if it finds a positive value. My actual spreadsheet will be 10's of thousands of rows that will change values for every data pull, so I would prefer to have a formula that can populate this easily!

I should note that my column B dollar values will always be sorted from largest to smallest within each Group prior to this calculation.

Thanks for the help.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(B2<0,0,SUMIFS(B:B,B:B,">0",A:A,A2))

 

[JLopez123]

Works perfectly!! Thank you so much!!

 

[Fluff]

You're welcome & thanks for the feedback.