Sumifs + match formula

[brandybartz]

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)

** MATCH($C7,'Item Types ST Weekly'!$A$5:$A$2357)

<tbody>
</tbody>

 

[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).