# sumif

#### securityman

##### Board Regular
I've been working on a sumif formula that I can't get to work.
In k13:k32 I have a state name (Mississippi, Alababma, etc).
In I13:I32 I have weights (185,000 - 196,500 etc)
in H13:H32 I have products (Chips, Fuel, etc)

I need a sumif (or other) formula that will give me the sum of all the weights where k13:k32="Mississippi" and h13:h32="Fuel". If that is true then sum I13:I32 that match and divide that answer by cell H5.

I worked on this for over an hour at work this morning and couldn't get it to do right. Any help would be appreciated!!!

Thanks,
Don

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### bbott

##### Well-known Member
Try:

=SUMIFS(I13:I32,K13:K32,"Mississippi",H13:H32,"Fuel")/H5

#### VoG

##### Legend
Try

=SUMPRODUCT(--(K13:K32="Mississippi"),--(H13:H32="Fuel"),I13:I32)/5

#### securityman

##### Board Regular

Thanks guys....I'll try both of these when I get back to work.

Replies
0
Views
150
Replies
3
Views
181
Replies
30
Views
744
Replies
4
Views
348
Replies
14
Views
758

1,191,517
Messages
5,987,063
Members
440,074
Latest member
Emmanuelian

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