help! multiple criteria for Sum data

[rachellashley]

I have two columns:

Business group Total Hours
Group 1 +50
Group 5 -22
Group 4 +20
Group 1 -23

I need to Sum the number of positive hours per business group in one coulum and then the number of negative hours in another
I am trying to use Sumif but I can't seem to get my negative/positive criteria to work:

Sum if (first argument=Group 1 AND Second Argument = >1)
Sum if (first argument=Group 2 AND Second Argument = <1)

Please help and thank you!!

 

[jai9]

Hi,

Try,

=SUMIFS(B2:B5,A2:A5,"Group 1",B2:B5,">0")

=SUMIFS(B2:B5,A2:A5,"Group 1",B2:B5,"<0")

Jai

 

[rachellashley]

This worked!! Thank you so much!