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, 9 views)

Hi
try the following steps
1. Get rid of the merged cells above your table.
2. Make a header for each column ( say colour, fruit, nr)
3 Select a cell in th range - "Insert" Ribbon - Click "Table"
4. In the Table Tools ribbon that appeared select "summarize with Pivot Table"
5. Creat your PT as desired
6. After adding data, right click the PT and click " Refresh"

You can also add a small macxro to auto refresh, they are all over the Net

Good luck

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Ok Ive set up the data with the pivot table

Which tells me totals of each category but I can't get it to separate the 2 runs of green apples or keep everything in order like below.

Sum Up Table
Green Apples 127
Red Apples 98
Green Apples 139
Green Pears 62

Attached Files

Apples2.xlsx (13.4 KB, 9 views)

Sorry, I didn't understand what you needed.
Perhaps add a 4th column called "batch".
Enter 1 in D2 and in D3

Apply a PT to these four columns and move the "batch" to the first column in the PT.
That should do the trick

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank You, That works perfectly!!