First it doesn't appear you need SUMIFS. SUMIF will suffice.
Second the syntax of the formula needs attention.
=SUMIFS($H$3:$H$10,$C5,$K$3:$K$10,$E$12,INDEX($H$2:$L$10,0,,MATCH($E$1,$I$1:$L$1,+COLUMNS($E5:$E5-1))))
This syntax of INDEX has 4 arguments. If you are not aware of it the MATCH is invoking the 4th argument (Area) that does not apply here.
Remove the 0, from INDEX($H$2:$L$10,0,,MATCH($E$1,$I$1:$L$1,+COLUMNS($E5:$E5-1)))
Third the MATCH function is expecting a match type in the 3rd argument. Try replacing +COLUMNS($E5:$E5-1) with 0.
Fourth the range H$2:$L$10 starts in row 2. The criteria range $H$3:$H$10 starts in row 3. Make both those the same --- preferably 2 but 3 should work as well.
Fifth it appears the date row is irrelevant. If not and something else is to be considered the same that holds for point four holds for the match range $I$1:$L$1. The index range is in columns H:L. Make those the same --- both I or H.
Sixth dispense with the date references and apply the % and L/G-Thruput criteria to the range H2:L2 in the MATCH function.
Please try in E5 filled down and across and see the attached.
Bookmarks