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)

מחבר
Jan-Erik Lärka
Application
Calc
סיווג
Business: Miscellaneous
License

BSD

תגיות
sum, group, conditional formatting
דירוג
0

עדיין אין הצבעות

Calculate Sum Upward Dynamically
סטטיסטיקות
Week: 0 - חודש: 0 - שנה: 0 - Timeline

Group Sum calculation and conditional formatting