excell percentages across columns

E

Ed

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
 
D

Dave Peterson

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.
 
Top