Help with SUMIF formula

[Irv]

I need help with the following sumif formula

A B C D E F
1 Req stock dyed greige miss over
2 500 100 200 100 150
3 500 100 200 500 50

the formula in e2 should be sum of a1-b1-c1-(d1 divided by 2)
if the total is less than A2 it has to show in e2, if greater than A2 it has
to show in F2
A B C D
500- 100- 200- (50)



in another sheet i do the same but greige [d2] is not divided by 2, just
subtracted
A1-B1-C1-D1

A B C D E F
1 Req stock dyed greige miss over
2 500 100 200 100 100
3 500 100 200 500 300

Thank You
Irv

 

[Irv]

Thank You
Works great
Irv

How about in e2

=IF(A2-B2-C2-(D2/2)>0,A2-B2-C2-(D2/2),"")

and f2

=IF(A3-B3-C3-(D3/2)<0,ABS(A3-B3-C3-(D3/2)),"")

-----Original Message-----
I need help with the following sumif formula

A B C D E F
1 Req stock dyed greige miss over
2 500 100 200 100 150
3 500 100 200 500 50

the formula in e2 should be sum of a1-b1-c1-(d1 divided by 2)
if the total is less than A2 it has to show in e2, if greater than A2 it has
to show in F2
A B C D
500- 100- 200- (50)



in another sheet i do the same but greige [d2] is not divided by 2, just
subtracted
A1-B1-C1-D1

A B C D E F
1 Req stock dyed greige miss over
2 500 100 200 100 100
3 500 100 200

500 300

Thank You
Irv



.