subtotal text groupings that change daily

[JJI]

I am a mid-level Excel user and slightly-more-than-novice VBA user. I'd like to be able to subtotal values within a text grouping, with the result displayed next to the last line in the text grouping. I tried SUMIF, but it returned subtotal for ALL matching text in my TYPE column. I want to subtotal EACH INSTANCE of matching text in my TYPE column. Then I'd like to subtotal those values within a different text group in my ACCOUNT column. Number of lines & types in each account can change daily. Is there Excel formula or VBA code to do this? Example of desired result attached.

Fidelity Daily Totals TEST.xlsx
	B	C	D	E	F	G	H
1	ACCOUNT	SYMBOL	VALUE	TYPE	SUBTOT TYPE	% TYPE	SUBTOT ACCT
2	XXX	SRLN	4585.00	BL/Pref
3	XXX	VTA	12661.00	BL/Pref	17246.00	0.09
4	XXX	BSCM	21640.00	Bond
5	XXX	BSJL	13815.00	Bond
6	XXX	BSJM	46580.00	Bond
7	XXX	BSJN	2530.00	Bond	84565.00	0.43
8	XXX	SPAXX (Core account)	17923.32	Cash	17923.32	0.09
9	XXX	GSY	50470.00	ST Bond
10	XXX	JPST	25370.00	ST Bond	75840.00	0.38
11	XXX	SPHD	871.00	Stock
12	XXX	XLE	1976.94	Stock	2847.94	0.01	198422.26
13	ZZZ	SRLN	9170.00	BL/Pref
14	ZZZ	VTA	1151.00	BL/Pref
15	ZZZ	VTA	10359.00	BL/Pref
16	ZZZ	VVR	2105.00	BL/Pref
17	ZZZ	VVR	4210.00	BL/Pref	26995.00	0.12
18	ZZZ	BSCL	6336.00	Bond
19	ZZZ	BSCM	21640.00	Bond
20	ZZZ	BSJL	23025.00	Bond
21	ZZZ	BSJM	5822.50	Bond
22	ZZZ	BSJM	40757.50	Bond
23	ZZZ	BSJN	2530.00	Bond	100111.00	0.43
24	ZZZ	SPAXX (Core account)	16076.75	Cash	16076.75	0.07
25	ZZZ	KBWY	567.25	Reit	567.25	0.00
26	ZZZ	GSY	50470.00	ST Bond
27	ZZZ	JPST	30444.00	ST Bond	80914.00	0.35
28	ZZZ	SPHD	3266.25	Stock
29	ZZZ	XLE	235.35	Stock
30	ZZZ	XLE	2118.15	Stock
31	ZZZ	XLP	699.20	Stock	6318.95	0.03	230982.95
Sheet1

Cell Formulas
Range	Formula
F3,F27,F12,F10	F3	=SUM(D2:D3)
G3,G12,G10,G7:G8	G3	=F3/$H$12
F7,F31	F7	=SUM(D4:D7)
F8,F24:F25	F8	=SUM(D8)
H12	H12	=SUM(F2:F12)
F17	F17	=SUM(D13:D17)
G17,G31,G27,G23:G25	G17	=F17/$H$31
F23	F23	=SUM(D18:D23)
H31	H31	=SUM(F13:F31)

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H
1		ACCOUNT	SYMBOL	VALUE	TYPE	SUBTOT TYPE	% TYPE	SUBTOT ACCT
2		XXX	SRLN	4585	BL/Pref
3		XXX	VTA	12661	BL/Pref	17246.00	0.09
4		XXX	BSCM	21640	Bond
5		XXX	BSJL	13815	Bond
6		XXX	BSJM	46580	Bond
7		XXX	BSJN	2530	Bond	84565.00	0.43
8		XXX	SPAXX (Core account)	17923.32	Cash	17923.32	0.09
9		XXX	GSY	50470	ST Bond
10		XXX	JPST	25370	ST Bond	75840.00	0.38
11		XXX	SPHD	871	Stock
12		XXX	XLE	1976.94	Stock	2847.94	0.01	198422.26
13		ZZZ	SRLN	9170	BL/Pref
14		ZZZ	VTA	1151	BL/Pref
15		ZZZ	VTA	10359	BL/Pref
16		ZZZ	VVR	2105	BL/Pref
17		ZZZ	VVR	4210	BL/Pref	26995.00	0.12
18		ZZZ	BSCL	6336	Bond
19		ZZZ	BSCM	21640	Bond
20		ZZZ	BSJL	23025	Bond
21		ZZZ	BSJM	5822.5	Bond
22		ZZZ	BSJM	40757.5	Bond
23		ZZZ	BSJN	2530	Bond	100111.00	0.43
24		ZZZ	SPAXX (Core account)	16076.75	Cash	16076.75	0.07
25		ZZZ	KBWY	567.25	Reit	567.25	0.00
26		ZZZ	GSY	50470	ST Bond
27		ZZZ	JPST	30444	ST Bond	80914.00	0.35
28		ZZZ	SPHD	3266.25	Stock
29		ZZZ	XLE	235.35	Stock
30		ZZZ	XLE	2118.15	Stock
31		ZZZ	XLP	699.2	Stock	6318.95	0.03	230982.95
32
Staff

Cell Formulas
Range	Formula
F2:F31	F2	=IF(AND(B2=B3,E2=E3),"",SUMIFS(D:D,B:B,B2,E:E,E2))
G2:G31	G2	=IF(F2="","",F2/SUMIFS(D:D,B:B,B2))
H2:H31	H2	=IF(B2=B3,"",SUMIFS(D:D,B:B,B2))

 

[JJI]

Yay Fluff! Exactly what was needed and works perfectly. Many thanks.

 

[Fluff]

You're welcome & thanks for the feedback.