Sum multiple cell based on another cell's date

[DailyCaffeine]

Good afternoon,
I would like some help with trying to make the formula I want.

Management Acc. Spreadsheet

"Actual" Spreadsheet

I am trying to make it so that the Year to Date adds up all the Global sum from April up until the date specified in A4 but I am unsure how to do it.
I have tried doing the following formula but I am guessing it is not working because it's using both columns and rows.

=SUMIFS('[Actual Spreadsheet.xlsx]Sheet 1'!$E$9:$J$12,'[Actual Spreadsheet.xlsx]Sheet 1'!$E$7:$J$7,"<="&A4,'[Actual Spreadsheet.xlsx]Sheet 1'!$D$9:$D$12,A11)

Please let me know what I am doing wrong and what I should be doing instead, it will be greatly appreciated !

 

[Fluff]

How about

=SUMPRODUCT(('[Actual Spreadsheet.xlsx]Sheet 1'!$E$7:$J$7<=A4)*('[Actual Spreadsheet.xlsx]Sheet 1'!$D$9:$D$12=A11)*('[Actual Spreadsheet.xlsx]Sheet 1'!$E$9:$J$12))

 

[DailyCaffeine]

Thank you very much ! This works perfectly !

 

[Fluff]

You're welcome & thanks for the feedback.

 

[DailyCaffeine]

Good afternoon,

Would you happen to know another way of doing this but for a bigger spreadsheet? I have tried implementing this on the spreadsheet I am using but it returns as error.

 

[Fluff]

What is the error?

 

[DailyCaffeine]

The cell shows up as #N/A because I am using E7:P7, D9:D130, E9:P130 for the formulas respectively

 

[Fluff]

That should not be a problem.
I would only expect a #N/A error if one of the cells the formula looks at contains that error, or if the ranges are not the same size.