Sample table for query sum

	A	B	C	D	E	F	G
1	Name	Last	Expenses		Name	Last	Expenses
2	Bruce	Wayne	100		Bob	Wayne	150
3	Jack	Napier	75		Bruce	Wayne	150
4	Bruce	Wayne	50		Byron	Wayne	150
5	Jack	Napier	5		Selena	Kyle	90
6	Selena	Kyle	90		Jack	Napier	80
7	Bob	Wayne	150
8	Byron	Wayne	150
9
10				Formula in E1:	=query(A1:C6,"select A, B, sum(C) group by B, A order by sum(C) desc, B, A label sum(C) 'Expenses'",1)
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100