Index match then returning a range of date values

[jenniesmith]

Hi Everyone!

An Index Match works well for me to return a date and address off of a list but if I want to return a sum of the prior 14 days from the look up date or the prior 90 days. How can I write to capture a sum of dates still using a look up on 2 criteria. Below is an example of the table. I am using =SUMIF(Data!$A$6:$A$147,$B$7,INDEX(Data!$B$6:$FR$147,0,MATCH($B$5,Data!$B$5:$FR$5,0))) for my look up to return one value.


Sum of Total Gross Adds & Reacts Column Labels
Row Labels 9/1/2014 9/2/2014 9/3/2014 9/4/2014 9/5/2014
Blah Blah Account 37 43 52 58 82
698 Iliff Ave 2 0 3 2 0
520 E Iliff Ave Suite G 0 0 0 0 0
220 E Iliff Ave Suite G 7 5 1 2 4
270 E 6th Ave Unit 5 0 0 0 0 0
5270 E 6th Ave. Unit 5 5 3 5 2 2
628 E. Bruce Randolph 4 4 2 3 5
930 havana st 2 1 1 0 0


Thanks for your help everyone!

Jennie

[bebo021999]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[jenniesmith]

Thanks. Here is a sample. I am looking to put in for the yellow highlighted cells.

[bebo021999]

To sum 7 day prior:

=SUMPRODUCT(OFFSET($A$1,MATCH($B$22,$A$1:$A$10,0)-1,MATCH($B$20,$A$2:$T$2,0)-1,,-7))

Change the number -7 to +7 or -90 ...