Quote:
Originally Posted by Spencer101
I'm in the UK too.
Is there a reason you're using that product array formula? Is it used to create a specific number or should it just showing a combined total for three months? Replying from my phone so cannot view the spreadsheet right now.
|
Not a problem, I'm not 100% sure why I use the product array formula, I'm fairly new to excel, only been using it about 6 months, and a lot of stuff I was shown and that was one of them. I think it's something to do with that fact that the percentages represent investment returns so as the return increases so does the increase in the percentage, so a simple sum(...) does not add it up correctly in the context of the sum. If that makes sense...although that is just my assumption.