View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Finding percents of a total

=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!