I have set up a sheet to track windshields sold per week. We have a weekly workbook and on the last page of each week is 4 tables from each week's workbook that tracks the top 10 windshields sold per week and how many. I would like a 5th table that has the top 10 for the month, but adds how many were sold for each top 10 for the 4 week period. So row E4-E52 is called count and this has 4 tables from each week, F4-F52 has the part # of the windshields. I just want that if in week one a DW2415 has 4 sold and week 2 has DW2415 at 3 sold, the monthly table would put DW2415 as one of the top 10 and count 7 for DW2415.
123.8 KB Views: 10