View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Computing Mutual Fund Diversification

I have MS Excel 97, and this is my first attempt to automate a
computation. Worksheet with Funds in successive rows, each row having
columns for capitalization class, NAV, value, etc. I would like to
automatically sum up the value for all funds in a class separately,
then divide it by total portfolio value to get a percent. Any help
would be appreciated. Thanks.