Sumifs + match formula

[brandybartz]

[TABLE="class: cms_table"]
<tbody>[TR]
[TD="width: 849, bgcolor: transparent"]I am able to get the below to return the correct values but I need it to do a match instead of me telling which row to look at

=SUMIFS('Item Types ST Weekly'!$D7:$BD7,'Item Types ST Weekly'!$D$2:$BD$2,">="&$D7,'Item Types ST Weekly'!$D$2:$BD$2,"<="&$E7)
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]** MATCH($C7,'Item Types ST Weekly'!$A$5:$A$2357)
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1085475-adding-match-sumif-formula.html#post5216326

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).