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
Here, try this in C1:
=$B1/SUMIF($A$1:$A$100,$A1,$B$1:$B$100)
and pull down.
Extend range (red) as much as you need
"Relax. What is mind? No matter. What is matter? Never mind!"
In C1 and copy down, =B1 / SUMIF($A$1:$A$11, A1, $B$1:$B$11)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Thanks so much guys. This was great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks