Sum Negative & Positives with Conditions

[Mgmy04]

Hello. I need help summing up the negatives and postive numbers on a separate summary sheet and hope someone can help me. I have three columns:

ColmnA	Column B	Column C
801	50	55
801	50	52
502	48	46
801	50	46
801	50	48

<tbody>
</tbody>

On my summary page, I am looking for is a formula that will subtract coulmn B from Column C for all 801's (Column A) and then take all those negatives and total them up. In this example, on my summary page I should see a value of -7 on my summary page. I am also looking to the same for the postive numbers. I should see a value of 6 on my summary page.

Any help would be greatly appreciated.

Thank you in advance for your help.

 

[chicagocomputerclasses]

Apply using ctrl-shift-enter

Negatives:

=SUM(--(IF(A2:A7=801,IF((B2:B7-C2:C7) < 0,B2:B7-C2:C7,0))))

Positives:

=SUM(--(IF(A2:A7=801,IF((B2:B7-C2:C7) > 0,B2:B7-C2:C7,0))))

 

[Scott Huish]

Or, without CTRL-SHIFT-ENTER

Negatives: =SUMPRODUCT(--(A2:A6=801),--(B2:B6-C2:C6<0),B2:B6-C2:C6)
Positives: =SUMPRODUCT(--(A2:A6=801),--(B2:B6-C2:C6>0),B2:B6-C2:C6)

 

[Mgmy04]

This worked perfectly. Thank you for your help!!