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