I would have liked to make an updating table that changes from month to month in order to check up my incoms and outcoms and create some statistic charts.
Therefore, the length of the columns in the spreadsheet will get longer and longer.
Is there an option to make the function arguments changeable or should I change all the functions once a month?
To work with a range of data that will be growing over time it is best to create a dynamic named range for the data and use the name in a formula rather than hard-coded cell references.
example: =SUM(Costs)
Where "Costs" is the name of a range of cells
See this link: Dynamic Named Range
More help here: Dynamic Named Ranges
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks