Forum Discussion
How to create an indirect range reference
How do I create an indirect reference to a range for an average() or Max() function? So if I want to display the average value in a part of a column, but the part is changeable. Today I want ...
Depending on your data arrangement, you may might arrive at your goal by tabling the data and using the totals row feature. You can toggle the total row on/off as needed when adding more data. It will always be at the bottom. This avoids volatile functions and references to entire columns.