Sum rows with same value and colums until a specific date

Hello all,

I'm struggling with a formula and can't figure it out. I have a matrix of data (rows with names and columns with dates).
I'm looking for a formula to add the row values until a specific date/column. In cell E1 I have the name it needs to match in the rows.
So far I have the following; =SUMIFS(INDEX($A$4:$AJ$99;MATCH($E$1;$A$4:$A$99;0);0);$A$4:$AJ$4;"<"&$G$1).

But this only adds 1 row until the correct date, while I have at least 3 rows with the same name as in cell E1.

Can anyone tell me what I am doing wrong?

Please see the yellow banner at the top of the page - it tells you how to attach your workbook.

try
=SUMPRODUCT((B9:B22=E1)*(D4:Q4<=G1)*(D9:Q22))