Percentage of 3 columns

[veeters2002]

Hi guys...

I am having a hard time finding the right way to accomplish this... What I am trying to do is to be able to key a number into 3 columns (A,B, & C) and then get the percentage that each number is of the sum in the next 3 columns. So, enter a number into column A, B, and C and then have D,E, and F tell me the percentages. So, D would be what percentage A is of the sum of the 3 original numbers (AB&C). E is the percentage calculation of what B is of the sum of the 3 original numbers (AB&C). F is the percentage C is of the sum of the original 3 numbers (AB&C).

I hope that makes sense and any assistance provided would be greatly appreciated.

Thanks!

[MrShorty]

Seems like it should be as simple as =A1/SUM($A1:$C1). Note the mix of relative and absolute references, then copy across two more columns then down as many rows as needed. Of course, this gives the result as a fraction of the total, you can then use number formatting to display the fraction as a percent.