Excel 2007 : Sumif, Index, match formula

Hi all,

I am trying to create a formula that will sum total OH units based on each category in column A (ie summer 1) from my data dump (MF dump) regardless of where the total OH units column is located on the data dump.

My supervisor keeps having me add things to this spreadsheet so I wanted to use sumif, index and match so that it wouldnt matter if he asks for future changes to the spreadsheet.

Please help!

This is al I could come up with
=SUMIF('MF Dump'!$B:$B,'Men''s Fashion'!$A10,(INDEX(MATCH('Men''s Fashion'!$B$5,'MF Dump'!$E:$Y,0),'MF Dump'!$E:$Y,)))

but it doesnt work





BOP Inventory Composition.xlsx