Sumproduct with subtotal with filter

[pugazh]

OK Formula returns value:
=IF(J$1="F1",SUMPRODUCT(SUBTOTAL(109,OFFSET($F$11,ROW($F$11:$F$200)-ROW($F$11),)),J$11:J$200,$B$11:$B$200),IF(J$1="TGA",SUMPRODUCT(SUBTOTAL(109,OFFSET($F$11,ROW($F$11:$F$200)-ROW($F$11),)),J$11:J$200,$C$11:$C$200),0))

Not returning value when additional arguments are added: What is wrong with this 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=$L5),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=$L5),0))

 

[Aladin Akyurek]

Try...

1.

=SUMPRODUCT(SUBTOTAL(109,OFFSET($F$11,ROW($F$11:$F$200)-ROW($F$11),0)),J$11:J$200,INDEX($B$11:$C$200,0,MATCH(J$1,{"F1","TGA"},0)))

2.

=SUMPRODUCT(SUBTOTAL(109,OFFSET($E$11,ROW($E$11:$E$200)-ROW($E$11),0)),J$11:J$200,($L$11:$L$200=$L5)+0,INDEX($B$11:$C$200,0,MATCH(M$1,{"F1","TGA"},0))

 

[pugazh]

Try...

1.

=SUMPRODUCT(SUBTOTAL(109,OFFSET($F$11,ROW($F$11:$F$200)-ROW($F$11),0)),J$11:J$200,INDEX($B$11:$C$200,0,MATCH(J$1,{"F1","TGA"},0)))

2.

=SUMPRODUCT(SUBTOTAL(109,OFFSET($E$11,ROW($E$11:$E$200)-ROW($E$11),0)),J$11:J$200,($L$11:$L$200=$L5)+0,INDEX($B$11:$C$200,0,MATCH(M$1,{"F1","TGA"},0))

Excellent. It works. Thank you very much. In-fact your formula is much simpler.

 

[Aladin Akyurek]

Excellent. It works. Thank you very much. In-fact your formula is much simpler.

You are welcome.