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!

=B1/SUM(B1:B50)


"experientman" wrote:

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!

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.
--
when u change the way u look @ things, the things u look at change.


"experientman" wrote:

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!