# Sum Index Match help needed

1. ## 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!

2. ## Re: Sum Index Match help needed

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

3. ## Re: Sum Index Match help needed

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

4. ## Re: Sum Index Match help needed

Change B2:H2, in Ben's formula to:

INDEX(B2:H3,MATCH(F9,A2:A3,0),0)

So finally,

=SUMIFS(INDEX(B2:H3,MATCH(F9,A2:A3,0),0), B1:H1, ">="&D9, B1:H1, "<"&D9+E9)

5. ## Re: Sum Index Match help needed

Awesome! Thank you everyone for the great Help!

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1