Help with SUMIF formula

  • Thread starter Thread starter Irv
  • Start date Start date
I

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
 
Thank You
Works great
Irv

Lance said:
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
Click to expand...
500 300
Thank You
Irv



.
Click to expand...
Click to expand...
 
Back
Top