excell percentages across columns
 

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.

Ed wrote:

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

--

Dave Peterson