Index Match with SUMIF for duration or match for dates in between.

Hello,

I found a similar post to this but doesn't completely answer my needs.

I have a table that has a quantity data that's organized like a weekly calendar.

I want to create another table (A19:E26) that gets the total amount for the selected Duration Date (A22) & End (B22),Item Name (C22), and Location (D21) - result to display on D22. Respectively for Location (E21) - result to display on E22.

I was able to do an index match for specific single dates, but could not figure out how to do like a sumif for a duration.

Help!

Sample Data