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

Thanks my bro