Sumproduct with offset and subtotal with filters

[Pugazh]

I am able to get weight with variants (Base, Mid, Upr, Prm and Sprt) with formula
=IF(J$1="F1",SUMPRODUCT(SUBTOTAL(109,OFFSET($E$11,ROW($E$11:$E$200)-ROW($E$11),)),J$11:J$200,$B$11:$B$200),IF(J$1="TGA",SUMPRODUCT(SUBTOTAL(109,OFFSET($E$11,ROW($E$11:$E$200)-ROW($E$11),)),J$11:J$200,$C$11:$C$200),0)).

Unable to get weight for Material types (ABS, HDPE, PBT, PCABS, POM, PP) with the below formula.
=IF(M$1="F1",SUMPRODUCT(SUBTOTAL(109,OFFSET($E$11,ROW($E$11:$E$200)-ROW($E$11),)),J$11:J$200,$B$11:$B$200,$L$11:$L$200=$L4),IF(M$1="TGA",SUMPRODUCT(SUBTOTAL(109,OFFSET($E$11,ROW($E$11:$E$200)-ROW($E$11),)),J$11:J$200,$C$11:$C$200,$L$11:$L$200=$L4),0))

Sample excel file attached for reference.

 

[bosco_yip]

Cross post :

https://www.mrexcel.com/forum/excel-questions/1032066-sumproduct-subtotal-filter.html