-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules