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
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: