Is there any quick way to calculate a % weight down a long list of items? For instance, is there a formula that will look to column 1 when summing the values in column 2?


Value Weight
A 1 5%
A 5 24%
A 4 19%
A 4 19%
A 5 24%
A 1 5%
A 1 5%
B 6
B 5
B 8
B 1
C 3
C 2
C 1