Why not use a Pivot Table?


A
B
C
D
E
F
G
1
Col A
Col B
Col C
Row Labels
Sum of Col C
2
A
AA
50
A
3
A
AA
50
AA
195
4
A
AA
25
A Total
195
5
A
AA
40
B
6
A
AA
20
BB
46
7
A
AA
10
B Total
46
8
C
9
B
BB
11
CC
1247.7
10
B
BB
15
C Total
1247.7
11
B
BB
2
(blank)
12
B
BB
3
(blank)
13
B
BB
4
(blank) Total
14
B
BB
5
Grand Total
1488.7
15
B
BB
6
16
17
C
CC
1.5
18
C
CC
2.6
19
C
CC
3.6
20
C
CC
5
21
C
CC
10
22
C
CC
15
23
C
CC
20
24
C
CC
25
25
C
CC
30
26
C
CC
35
27
C
CC
100
28
C
CC
1,000.00




Regards, TMS