Calculating weights down a list

[Excelp2029]

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

[MrShorty]

For instance, is there a formula that will look to column 1 when summing the values in column 2?

That sounds like a SUMIFS() function: https://support.office.com/en-us/art...6-611cebce642b Something like SUMIFS($B$2:$B$200,$A$2:$A$200,A2) [note the mix of relative and absolute references for easy copying] would sum up the values in column B based on the letter entered in column A. If I understand what you mean by "weight" percent in this case, simply divide that result into each value =B2/SUMIFS($B$2:$B$200,$A$2:$A$200,A2)

[Excelp2029]

You sir, are incredible. Thank you!

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.