vlookup() with sumifs() to summarize between two numbers?

Attempting to summarize car expenses occurring between two mileages, varying by manufacturer. Expenses are in a separate range, and individual cars are in a table.

I think this requires combination of vlookup() and sumifs(), but am not sure how to combine the two functions. Also, the mileages need to be rounded and divided before making the match.

Here is my goal. Spreadsheet is attached.

example.png

Any takers?

Thanks!

Untitled.png

Annotated example

Thanks for responding. I think I made the example more complex than necessary....sorry about that.

Here's a simplified example:

xl_question_screenshot.png

I would like to cell D9 sum every cell in the "source" range which matches "Ford" and is >= 10,000 and <= 30,000.

Thank you very much, that works perfectly!