Mixing subtotal and sumif

[Dexir]

Hi Experts, Greetings!
I have this sheet, sumif is working fine, but i want to get the quantity of A Range and B Range in F2 and F3, if i do filter any specific packing. Thanks in advance.

Book1
	A	B	C	D	E	F	G
1
2					A RANGE	174
3					B RANGE	307
4	Packing Size	Range	Qty
5	30X30	B RANGE	20
6	15X15	A RANGE	26
7	18X24	A RANGE	27
8	30X30	B RANGE	28
9	15X15	B RANGE	90
10	18X24	B RANGE	40
11	30X30	B RANGE	80
12	15X15	B RANGE	49
13	30X30	A RANGE	61
14	15X15	A RANGE	48
15	15X15	A RANGE	12
16
Sheet1

Cell Formulas
Range	Formula
F2	F2	=SUMIF($B$5:$B$15,$E$2,$C$5:$C$15)
F3	F3	=SUMIF($B$5:$B$15,$E$3,$C$5:$C$15)

 

[Sam_D_Ben]

Please check.

Book1
	E	F	G
5	15X15	A RANGE	86
6	15X15	B RANGE	139
7	18X24	A RANGE	27
8	18X24	B RANGE	40
9	30X30	A RANGE	61
10	30X30	B RANGE	128
Sheet1

Cell Formulas
Range	Formula
G5:G10	G5	=SUMIFS($C$5:$C$15,$B$5:$B$15,$F5,$A$5:$A$15,$E5)

Thanks

 

[Dexir]

Sir, i don't want in G column, i just want if i do filter any of packing, the sum of A Range and B range of filtered packing showing in A range in F2 and B range in F3.

 

[Sam_D_Ben]

May be this ?

Book1
	A	B	C	D	E	F
2					A RANGE	174
3					B RANGE	307
4	Packing Size	Range	Qty
5	30X30	B RANGE	20
6	15X15	A RANGE	26
7	18X24	A RANGE	27
8	30X30	B RANGE	28
9	15X15	B RANGE	90
10	18X24	B RANGE	40
11	30X30	B RANGE	80
12	15X15	B RANGE	49
13	30X30	A RANGE	61
14	15X15	A RANGE	48
15	15X15	A RANGE	12
Sheet1

Cell Formulas
Range	Formula
F2:F3	F2	=SUMPRODUCT(SUBTOTAL(109,OFFSET(C5,ROW($C$5:$C$15)-ROW(C5),,1)),--($B$5:$B$15=$E2))

Thanks

 

[Dexir]

Yes this, Working perfectly. Thank you so much!