Calculate Sum Upward Dynamically

You can define your own id's and their meaning on one tab and just type the values to get a nicley formatted spreadsheet with sum at the top and partial/group sum in between.

The different id-ranges define how the spreadsheet group and calculate the sum of values you enter for each month.

The template contain 1 macro that take a number ( 1 to N ) and return the name of the N:th tab. This also allow you to rename the tabs but you have to change the calculations if you reorder the tabs.

Use the Additional tab to connect the speadsheet to an external data source that you want to merge. (You need to add the formulas and intergrate it with the rest yourself to use it)

Author
Jan-Erik Lärka
Application
Calc
Category
Business: Miscellaneous
License

BSD

Tags
sum, group, conditional formatting
Rating
0

No votes yet

Calculate Sum Upward Dynamically
Statistics
Week: 0 - Month: 0 - Year: 0 - Timeline

Group Sum calculation and conditional formatting