Summation

Hello all,

I have a very simple question. I have three columns.

Column A Column B Column C

e 5 =5/(5+4+3+6)
e 4 =4(5+4+3+6)
e 3 =3(5+4+3+6)
e 6 =6(5+4+3+6)
f 4 and so on
f 1
f 2
f 3
g 1
g 1
g 1

I was hoping to obtain a formula or vba code that would place the correction fraction in column C. This fraction would be the value in B divided by the sum of all the values in B for which the value in A is the same.

So I need some kind of conditional sum / vlookup or something. Any help you could give me would be greatly appreciated. Thank you very much

Michael

Thanks so much guys. This was great