willdow999
New Member
- Joined
- Sep 30, 2019
- Messages
- 3
Hello,
I have a fund with 46 assets. All of the asset pages are built exactly the same.
To roll them up, i use a rollup page, with each line of the rollup exactly the same as each asset tab
To roll them up I sum Sum(BEG:END!E257) for December and Sum(BEG:END!F257) for January, and so on so I can drag the formula to the right and have it sum each month
However, sometimes, in the sheet tabs I want to add a row. And this messes up the row numbers of the master sheet.
How do I create a formula, that makes me BEG:END Sum dynamic WITHOUT using the indirect function? I do not want to use the indirect function because it is very volite and this sheet is already too big to function as is.
I have a fund with 46 assets. All of the asset pages are built exactly the same.
To roll them up, i use a rollup page, with each line of the rollup exactly the same as each asset tab
To roll them up I sum Sum(BEG:END!E257) for December and Sum(BEG:END!F257) for January, and so on so I can drag the formula to the right and have it sum each month
However, sometimes, in the sheet tabs I want to add a row. And this messes up the row numbers of the master sheet.
How do I create a formula, that makes me BEG:END Sum dynamic WITHOUT using the indirect function? I do not want to use the indirect function because it is very volite and this sheet is already too big to function as is.