As I enter data over time (into the column populating the chart), the hypothetical portfolio size will grow, and it's growth is being averaged over time via the RRI function, giving us the average rate of return over time. Once I've entered new data into the fields and the tables pick it up, the RRI variable will need to increase: it must be able to count the amount of cells in the table array and use that number of counted cells as the RRI variable to form a proper average.
Example, if I was averaging 4 items I would sum them and divide by 4, however if I add a 5th item, I can no longer divide by 4 and must divide by 5 to reach a correct average. This '4' and '5' is the RRI variable I am using to properly calculate my average, represented by filled cells in a column, and will need to be automatically counted. The only question is how.
Example, if I was averaging 4 items I would sum them and divide by 4, however if I add a 5th item, I can no longer divide by 4 and must divide by 5 to reach a correct average. This '4' and '5' is the RRI variable I am using to properly calculate my average, represented by filled cells in a column, and will need to be automatically counted. The only question is how.
