sumif

[securityman]

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

 

[bbott]

Try:

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

 

[VoG]

Try

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

 

[securityman]

I keep forgetting about sumifs.....didn't even think about sumproduct.....

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