Sum Index Match help needed

Greetings all, I would like to know if it is possible to sum consecutive cells (in a row for instance), based on criteria matching the Column headers. The attached excel will provide further clarity to this question.

Thanks you very much!

Please Login or Register  to view this content.

This will sum all the dollar values in B2:H2 according to two criteria:
1) The corresponding number above it in range B1:H1 is more than or equal to the value in D9
2) The corresponding number above it in range B1:H1 is less than D9+E9

Originally Posted by ben_hensel

Please Login or Register  to view this content.

This will sum all the dollar values in B2:H2 according to two criteria:
1) The corresponding number above it in range B1:H1 is more than or equal to the value in D9
2) The corresponding number above it in range B1:H1 is less than D9+E9

Thank yo Ben_hensel

Good start but the formula needs to consider the value in F9 and match it to the appropriate row in my table (say A1:H3). If the value in F9 was HE00140, I need the formula to use the row corresponding to the value from F9 - in this second instance, H00140 (Row 3...)

Awesome! Thank you everyone for the great Help!