Assembly application. (simplifying using green apples, red apples, green pears)

127 green apples are ran down the assembly line, followed by 98 red apples, followed by another 139 green apples, then 62 green pears.


I sum these up each day by hand, and think there must be some way excel can do it automatically.

Problems I have ran into is excel does not want to grab consecutive orders it wants to grab all green apple orders and sum them up. I need to know how many are schedules to run in order.

Attached is a spread sheet to show what I am trying to say. I need data to automatically kick out in a table and update as the orders grow.

Thank you for your help

Attached Files

Apples.xlsx (9.5 KB, 11 views)