Needing to solve an sumif function

mmdmalta

New Member
Joined
Oct 9, 2006
Messages
40
Here is what i'm trying to accomplish in a formula. In the below chart. I want to have excel enter in the Adjustments cell, the $ amount listed under Comm $ column, only if "Bird Dog" or "Charge backs" are entered in the Type cell. Otherwise, I want to leave the Adjustment column blank. Here is the formula i'm using, but it seems to not be working. =SUMIF($F$3:$F$4,"Bird Dog Fee (to bird dog)"=SUMIF($f$3:f$4,"Charge backs"(h$3$h$4).

It seems i'm close, but i'm missing something. Please help!! Thank you.

Other Commission

Customer TBS# Quote # Sales $ Type Comm Rate Comm $ Adjustments
UP Ind 45213 12458 $2,215.06 Bird Dog 2.0% $44.00
humboltd 12345 21452 $1,140.00 Charge backs 10.0% $20.30
 
Last edited:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
=if( OR( TypeCell = "bird dog", TypeCell = "charge back" ) , $ cell , "")
if its a row by basis - but it appears its across 2 rows row3 and 4 - not sure i understand
 
Last edited:
Upvote 0
=if( OR( TypeCell = "bird dog", TypeCell = "charge back" ) , $ cell , "")
if its a row by basis - but it appears its across 2 rows row3 and 4 - not sure i understand

Oh, thank you, i managed to figure it out. I just added another cell and created a formula for each. One for Charge backs and one for bird dog... like this.

=SUMIF($E$4:$E$4,"Charge Backs",$G$4:$G$4)
=SUMIF($E$4:$E$4,"Bird Dog",$G$4:$G$4)

It seemed to work. Thank you anyway. I love this website thread!
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top