excell percentages across columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 6 columns of figure ( in this case votes) the 7th is the total across
for the row.
I now want to create an additional column for each column of votes and put
the percentage of each orignal column of the total in each., Col A is raw
vote, B the percentage of votes of the total col Col A is , colum C is raw
votes, Col D the percentage of total votes Col C is, etc

thanks
 
Insert a new column to the right of each of the 6 columns.
Then use a formula like:
=a1/$N1
and format as a percentage.
(where A1 contains the raw total and N1 contains the total)
And drag down each column
Do the same for each percentage column.
 
Back
Top