Accumulative Formula required for daily cadence?
Hope someone can help me. I want to keep track of the accumulative total for each spreadsheet.
For example see below - Tomorrow when i enter in Thursdays actual data of 5 - i would like:
- The bottom total to add up to Target total 160
- The Actual Column to add up to 105 (if actual number is 5 for the day)
- The +/1 Column to adjust itself to -55 (160-105).
The tricky part is i only want this to add up when i enter the Actual figure this can be any time of the day.
Thanks everyone for your help Chris