I'm hoping someone with a logical brain can help me.
I have a spreadsheet that measures daily performance for different operations. I would like the overall performance for all the separate operations the preceding day to be the target for the operations the following day. I thought I'd come up with a formula but I've noticed it doesn't deliver what I require.
I've attached a spreadsheet with a model of the information with a formula in column F that I thought would do the trick.
The information I would want to see returned by a formula is displayed in column G.
Any ideas folks would be appreciated.