Accumulative Formula required for daily cadence?

Accumulative Formula required for daily cadence?

Good Morning

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:

  1. The bottom total to add up to Target total 160
  2. The Actual Column to add up to 105 (if actual number is 5 for the day)
  3. 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

Best Answers

Answers

Sign In or Register to comment.