Sum Multiple Entries Through Index and Match

I'm having trouble with a formula that is trying to add multiple matches that relate to a certain cell.

I have a database that keeps track of miles traveled in each state as well as gallons of fuel used. I want to sort each entry by state and sum up the miles.

The formula I have is a sumif but when I change the state name the formula gives me a reference error

=SUMIF(Database!$D$2:$D$5000,I5,INDEX(Database!$E$2,MATCH(I5,Database!$D$2:$D$5000,0)))

Q4 Mileage Entry Form.xls

I have attached the file I have been working on. The formula is in K5.

Any help is greatly appreciated

Try this formula.

Formula:

Please Login or Register  to view this content.