What's the best way to sum many items based on certain conditions

[cytochrome]

Hi there,
Just wondering what's the best way to to sum the amount from table below:

AMOUNT	ACCOUNT	CODE
1	G111	CA1
2	G111	CA2
7	G111	CA1
3	G222	CA3
2	G555	CA3
4	G333	CA4
5	G333	CA4
6	G444	CA4

to this:

ACCOUNT	AMOUNT	CODE
G111	8​	CA1
G111	2​	CA2
G222	3​	CA3
G555	2​	CA3
G333	9​	CA4
G444	6​	CA4

The raw data file had about 10,000 rows with many different account numbers. So wondering what would be the best way to accomplish this? It would be amazing if there is a VBA that can accomplish this but will equally appreciated for any suggestion with Excel built-in formulas/functions.

 

[JamesCanale]

MrExcelPlayground19.xlsx
	A	B	C	D	E	F	G
1	AMOUNT	ACCOUNT	CODE
2	1	G111	CA1		G111	CA1	8
3	2	G111	CA2		G111	CA2	2
4	7	G111	CA1		G222	CA3	3
5	3	G222	CA3		G555	CA3	2
6	2	G555	CA3		G333	CA4	9
7	4	G333	CA4		G444	CA4	6
8	5	G333	CA4
9	6	G444	CA4
Sheet12

Cell Formulas
Range	Formula
E2:F7	E2	=UNIQUE(B2:C9)
G2:G7	G2	=SUMIFS(A2:A9,B2:B9,INDEX(E2#,,1),C2:C9,INDEX(E2#,,2))
Dynamic array formulas.

 

[cytochrome]

Thank you so much. This works very very well.