show today production with adding last previouses

in sheet 1 if 4/8/18 total planned is 210 and 5/8/18 planned is also 210. and if i enter in cell i2 5/8/18, it should show up final result out of 420 and if i enter 6/8/18 it should show out of 630 and so on....

Hi

Try this in J3, K3, L3 and copy down

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.