Cumulative count formula
I hope somebody can assist me.
I want to develop a production tracking sheet based on the simplified test sheet as per attached snip. The data is generated by a batch counter on equipment and at the end of the shift the production staff enter the daily total into the green cells and the sheet then calculates the total daily production by subtracting the counter total from previous day from the current day counter total.
The plan is for the total cumulative monthly and yearly production to be linked to a summary sheet and hopefully to a dashboard.
The problem that I'm faced with is that the running total calculation for month and year, using =SUM (CHILDREN()) formula, is impacted by the fact that the formula for the current day's production shows the previous day's counter reading (-100400 in the example) until such time as the end of shift counter reading is added to the sheet. The daily total will then be correct but the problem then transfers to the next day.
Therefore the cumulative production in any onwards summary or dashboard is is always going to be incorrect.
I hope I've explained the dilemma adequately. Can anybody advise on a solution?
Many thanks in advance.
Help Article Resources
Check out the Formula Handbook template!