That works when the total of the numbers was 50. I assume you used some kind of formula to arrive at the E:F columns and then it is as easy as multiplying them by 100.
When the sum of the numbers varies you would use a formula like the following in I2
=100*B2/Sum($B2:$D2)
You can then copy that formula across and down to build the table.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|