Consulting

Results 1 to 2 of 2

Thread: Macro to expand SUMPRODUCT Formula

  1. #1
    VBAX Newbie
    Joined
    Aug 2016
    Posts
    1
    Location

    Macro to expand SUMPRODUCT Formula

    Hello,

    I need your help, I have an exel file who contain an historic of performances of a portfolio, so many informations are in this file, and I want to make a "Custom Range" who will permit me to see the % of Nav, % Price Var, % FX Var %Realised P&L, %Int/Dvd and %Total.

    As you can see on my file (who is cut as 95% ....) is used a SUMPRODUCT Formula to create my custom range, if the date is in my range then 1, if not 0. And now I want to expand it, because the recap of performance who appear at the right in the PERFORMANCE EURO sheet will be bigger or shorter so I need a macro who permit to adapt my formula automatically.

    And in a second time, I have a problem for %NAV, I need to make a sum of them and then make a division by the umber of term, how can I do that ? I know that's not relly good to make an average of percentages but that's ok for my professor so...

    You can file the file as attachement.

    Test.zip

    Thank you for your answers

  2. #2
    Moderator VBAX Guru Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    4,997
    Location
    Is this based upon an assignment request by your professor?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •