Hello,
Happy New Year!

I hope you can help with the following.
I have a worksheet as follows:

col a---col b
1------ $(100)
2-------$50
3-------$20
2-------$(30)
4-------$10
4-------$(20)

I would like to sum colum b if the sum relating to col a is greater 0 i.e.

result: $40 based on:
col a----col b
1---------$0
2---------$20
3---------$20
4---------$0

Thank you so much!