SO in cloumn A i have country codes and Column B i have prices.

Example,

[TABLE="width: 128"]

[tr]

[TD="width: 64"]Mex[/TD]

[TD="width: 64, align: right"]10[/TD]

[/tr]

[tr]

[td]

usa

[/td]

[TD="align: right"]10[/TD]

[/tr]

[tr]

[td]

mex

[/td]

[TD="align: right"]-5[/TD]

[/tr]

[tr]

[td]

usa

[/td]

[TD="align: right"]-5[/TD]

[/tr]

[tr]

[td]

mex

[/td]

[TD="align: right"]3[/TD]

[/tr]

[tr]

[td]

usa

[/td]

[TD="align: right"]3[/TD]

[/tr]

[tr]

[td]

mex

[/td]

[TD="align: right"]-4[/TD]

[/tr]

[tr]

[td]

usa

[/td]

[TD="align: right"]-4[/TD]

[/tr]

[/TABLE]

I need four formulas that work, One that sums mexico > 0 , mexico < 0, Usa > 0 , and Usa < 0

How would i format this sumif function or is that even the right formula to use?

My attempt was =sumif(A1:B8,"mex",sumif(A1:B8,>0,B1:B8)) Which did absolutely nothing for me...

Please and thank you!