View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mbarron
 
Posts: n/a
Default Formula Needed...

Assuming A2 to Z2 are the frequencies:
in cell A3
=A2/SUM($A$2:$Z$2)

Copy the formula to the rest of the columns.