INDEX MATCH Return multiple data for YTD calculation

[BananaJo]

Greetings to all,

Now I have tackled this problem with the offset function, however I can not use it since I need to collect these data from different excel files in a different server. (I am getting a Value Error and need to have all these files opened)
My next solution would be to use the Index Match function, however I can't figure out how to receive multiple data.

Please find below the actual file:
https://drive.google.com/open?id=0B2...N5aXRoR2Z6VGVN

If I wanted to receive one cell data, that would be easy by using the function below:
=INDEX(D9:O20;MATCH(C4;C9:C20;0);MATCH(C5;D8:O8;0))

I cant seem to receive multiple data and sum them for YTD calculation. So if the column_num variable would be for any date lesser than the date in C5, how would we go about this, since the correct answer would be d9+e9?
I thought maybe this however I do not get any answer:
=INDEX(D9:O20;MATCH(C4;C9:C20;0);MATCH("<="&C5;D8:O8;0))

The way I did it with the offset function was :
=SUM(OFFSET(C8,MATCH(C4,C9:C20,0),1,,MATCH(C5,D8:O8)))

Thank you for your time and effort

[sandy666]

Better way is:

Attach a sample workbook. (Not a picture!)
Make sure there is just enough data to demonstrate your need. Include a BEFORE (original) sheet and an AFTER (required output) 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, it should reflect original structure of your data.
Remember to desensitize the data.
Note:

• Please do not attach password protected workbooks/worksheets
• Please do not attach file(s) from exterior servers
• Please do not attach file(s) with enabled any Workbook Open/Autorun macros!

20 rows of data is enough (probably)

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.