# Needing to solve an sumif function

#### mmdmalta

##### New Member
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).

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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### etaf

##### Well-known Member
=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:

#### mmdmalta

##### New Member
=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!

Replies
1
Views
464
Replies
21
Views
2K
Replies
8
Views
389
Replies
12
Views
979
Replies
3
Views
325

1,195,670
Messages
6,011,074
Members
441,581
Latest member
rp4717

### 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.

### Which adblocker are you using?

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

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