Finding percents of a total

[experientman]

Say I have a colum with 50 rows filled in with various numbers that add up to
1000. How do I create a function that would calculate the percentace of the
value from each row of the total (B1:B50/total)?

Any help would be greatly appreciated!

 

[Teethless mama]

=B1/SUM(B1:B50)

 

[sahafi]

If I understood you correctly, your data starts from B1:B50 and your total is
on cell B51. You would like to show percentages on column C (C1:C50).
Basically type = on c1 then click on B1 then the "/" division sign then click
on B51. Highlight the portion of B51 and press F4. Your formula now looks
like this:
=B1/$B$51
drag the formula all the way down to B:50.
Additionally, you could highlight the range C1:C50, right click >> format
cell >> number >> choose percentage.

H.T.H.