I've been working on this equation for a few days now to extract information based on matching criteria within a date range. A couple of formulas I've tried are index/match and sumifs but cant get either to work. So here is what I have, in columns B and C are my date ranges, column D is the product and E is the TPH. Then in column H I have my product I'm trying to match based on the date ranges by month in Row 2 going across. What I'd like to do is publish the TPH that corresponds with the product and the month it's located in I2:T10 (highlighted section).
Bookmarks