sum on multiple criteria

[opeyemi1]

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!

[NBVC]

Assuming you list the unique column a values in say, D1:D4, then in E1:

=MAX(0,SUMIF($A$1:$A$6,D1,$B$1:$B$6))

copied down

Adjust as necessary.

[opeyemi1]

Thank you.
Just wondering if there is another way to do this without having to list out the unique values in another column. The reason is that I am trying to design a template and so the unique values might be different for other users.

[NBVC]

Not sure what you mean.

Do you want a Pivot Table,

Which automatically lists the unique values and the respective sums?

[opeyemi1]

Thanks, I'll go with the max formula and extra column suggested instead of using a pivot table.