Imagine you have a budget spreadsheet, one column per month:
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Salary | Joe | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 |
| Salary | Mary | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 |
| Office Enhancements | Printer | 1000 |
What is the best way to have an aggregate sum “up to month X”.
E.g.
- Provided Month 3, we should see “Salary 12000” and “Office Enhancements 0”
- Provided Month 6, we should see “Salary 24000” and “Office Enhancements 1000”
Here is a playground sheet:
https://docs.google.com/spreadsheets/d/1IO4UHF2CIXnKIu5m8DBcHfP9Il6sW59hAGWJ0waj9KE/edit?usp=sharing