Trying to sum small groups of data within a large database

[ggd49404]

Good morning! I'm currently looking for help on a problem I've been facing in Excel. I'm trying to process a massive amount of data. To be specific, I'm referencing 17,352,100 rows. Fortunately, I don't plan on processing or working with all of them at once. I'm running sales data for different items. Each item has a daily sales amount. This means each item gets 365 rows just to itself. I'm looking to calculate everything down to thirteen four-week periods. I'm looking for a formula (or other solution) that will look at each item, pick out the four weeks worth of dates, and total the sales amounts for each day.

My plan is to set something up so that I can process about 500 items at a time, copy/paste the results, wash, rinse, and repeat. This will also be something that in the future, I can hopefully just alter the dates and use again. I can only think of formulas that are too long to create. Any help anyone can offer would be great.

Below, I have copied a sample of one of the codes. I need to break down the sales days into four week intervals. The first interval would be 10/08/14 to 11/07/14. If you have any questions or need any additional clarification, please let me know.

Code Sales Day Dollars Units
1 10/8/2014 $363.00 121.00
1 10/9/2014 $312.00 104.00
1 10/10/2014 $360.00 120.00
1 10/11/2014 $453.00 151.00
1 10/12/2014 $585.00 195.00
1 10/13/2014 $411.00 137.00
1 10/14/2014 $462.00 154.00
1 10/15/2014 $375.00 125.00
1 10/16/2014 $288.00 96.00
1 10/17/2014 $369.00 123.00
1 10/18/2014 $456.00 152.00
1 10/19/2014 $621.00 207.00
1 10/20/2014 $414.00 138.00
1 10/21/2014 $390.00 130.00
1 10/22/2014 $276.00 92.00
1 10/23/2014 $324.00 108.00
1 10/24/2014 $330.00 110.00
1 10/25/2014 $408.00 136.00
1 10/26/2014 $645.00 215.00
1 10/27/2014 $453.00 151.00
1 10/28/2014 $336.00 112.00
1 10/29/2014 $312.00 104.00
1 10/30/2014 $288.00 96.00
1 10/31/2014 $339.00 113.00
1 11/1/2014 $447.00 149.00
1 11/2/2014 $588.00 196.00
1 11/3/2014 $405.00 135.00
1 11/4/2014 $372.00 124.00
1 11/5/2014 $306.00 102.00
1 11/6/2014 $321.00 107.00
1 11/7/2014 $345.00 115.00
1 11/8/2014 $396.00 132.00
1 11/9/2014 $788.00 315.00
1 11/10/2014 $500.50 200.00
1 11/11/2014 $413.00 164.00
1 11/12/2014 $489.00 195.00
1 11/13/2014 $443.00 177.00
1 11/14/2014 $413.50 165.00
1 11/15/2014 $514.00 205.00
1 11/16/2014 $708.00 236.00
1 11/17/2014 $498.00 166.00
1 11/18/2014 $357.00 119.00
1 11/19/2014 $324.00 108.00
1 11/20/2014 $378.00 126.00
1 11/21/2014 $420.00 140.00
1 11/22/2014 $498.00 166.00
1 11/23/2014 $612.00 204.00
1 11/24/2014 $474.00 158.00
1 11/25/2014 $527.25 176.00
1 11/26/2014 $300.00 100.00
1 11/27/2014 $33.00 11.00
1 11/28/2014 $294.00 98.00
1 11/29/2014 $357.00 119.00
1 11/30/2014 $576.00 192.00
1 12/1/2014 $429.00 143.00
1 12/2/2014 $369.00 123.00
1 12/3/2014 $366.00 122.00
1 12/4/2014 $273.00 91.00
1 12/5/2014 $441.00 147.00
1 12/6/2014 $489.00 163.00
1 12/7/2014 $600.00 200.00
1 12/8/2014 $591.00 197.00
1 12/9/2014 $378.00 126.00
1 12/10/2014 $363.00 121.00
1 12/11/2014 $360.00 120.00
1 12/12/2014 $408.00 136.00
1 12/13/2014 $429.00 143.00
1 12/14/2014 $792.00 264.00
1 12/15/2014 $354.00 118.00
1 12/16/2014 $282.00 94.00
1 12/17/2014 $315.00 105.00
1 12/18/2014 $357.00 119.00
1 12/19/2014 $351.00 117.00
1 12/20/2014 $351.00 117.00
1 12/21/2014 $630.00 210.00
1 12/22/2014 $357.00 119.00
1 12/23/2014 $363.00 121.00
1 12/24/2014 $393.00 131.00
1 12/26/2014 $294.00 98.00
1 12/27/2014 $387.00 129.00
1 12/28/2014 $474.00 158.00
1 12/29/2014 $420.00 140.00
1 12/30/2014 $348.00 116.00
1 12/31/2014 $384.00 128.00
1 1/1/2015 $186.00 62.00
1 1/2/2015 $414.00 138.00
1 1/3/2015 $423.00 141.00
1 1/4/2015 $681.00 227.00
1 1/5/2015 $429.00 143.00
1 1/6/2015 $282.00 94.00
1 1/7/2015 $342.00 114.00
1 1/8/2015 $420.00 140.00
1 1/9/2015 $426.00 142.00
1 1/10/2015 $573.00 191.00
1 1/11/2015 $789.00 263.00
1 1/12/2015 $366.00 122.00
1 1/13/2015 $276.00 92.00
1 1/14/2015 $321.00 107.00
1 1/15/2015 $375.00 125.00
1 1/16/2015 $357.00 119.00
1 1/17/2015 $408.00 136.00
1 1/18/2015 $573.00 191.00
1 1/19/2015 $474.00 158.00
1 1/20/2015 $393.00 131.00
1 1/21/2015 $243.00 81.00
1 1/22/2015 $279.00 93.00
1 1/23/2015 $567.00 189.00
1 1/24/2015 $363.00 121.00
1 1/25/2015 $777.00 259.00
1 1/26/2015 $213.00 71.00
1 1/27/2015 $267.00 89.00
1 1/28/2015 $285.00 95.00
1 1/29/2015 $312.00 104.00
1 1/30/2015 $360.00 120.00
1 1/31/2015 $642.00 214.00
1 2/1/2015 $612.00 204.00
1 2/2/2015 $285.00 95.00
1 2/3/2015 $324.00 108.00
1 2/4/2015 $291.00 97.00
1 2/5/2015 $366.00 122.00
1 2/6/2015 $405.00 135.00
1 2/7/2015 $384.00 128.00
1 2/8/2015 $648.00 216.00
1 2/9/2015 $414.00 138.00
1 2/10/2015 $333.00 111.00
1 2/11/2015 $324.00 108.00
1 2/12/2015 $351.00 117.00
1 2/13/2015 $351.00 117.00
1 2/14/2015 $393.00 131.00
1 2/15/2015 $417.00 139.00
1 2/16/2015 $534.00 178.00
1 2/17/2015 $270.00 90.00
1 2/18/2015 $327.00 109.00
1 2/19/2015 $288.00 96.00
1 2/20/2015 $441.00 147.00
1 2/21/2015 $621.00 207.00
1 2/22/2015 $537.00 179.00
1 2/23/2015 $420.00 140.00
1 2/24/2015 $297.00 99.00
1 2/25/2015 $303.00 101.00
1 2/26/2015 $321.00 107.00
1 2/27/2015 $336.00 112.00
1 2/28/2015 $519.00 173.00
1 3/1/2015 $683.00 228.00
1 3/2/2015 $498.00 166.00
1 3/3/2015 $441.00 147.00
1 3/4/2015 $519.00 173.00
1 3/5/2015 $219.00 73.00
1 3/6/2015 $366.00 122.00
1 3/7/2015 $423.00 141.00
1 3/8/2015 $720.00 240.00
1 3/9/2015 $438.00 146.00
1 3/10/2015 $357.00 119.00
1 3/11/2015 $426.00 142.00
1 3/12/2015 $387.00 129.00
1 3/13/2015 $378.00 126.00
1 3/14/2015 $465.00 155.00
1 3/15/2015 $696.00 232.00
1 3/16/2015 $369.00 123.00
1 3/17/2015 $363.00 121.00
1 3/18/2015 $249.00 83.00
1 3/19/2015 $384.00 128.00
1 3/20/2015 $291.00 97.00
1 3/21/2015 $396.00 132.00
1 3/22/2015 $633.00 211.00
1 3/23/2015 $438.00 146.00
1 3/24/2015 $312.00 104.00
1 3/25/2015 $297.00 99.00
1 3/26/2015 $333.00 111.00
1 3/27/2015 $285.00 95.00
1 3/28/2015 $456.00 152.00
1 3/29/2015 $732.00 244.00
1 3/30/2015 $348.00 116.00
1 3/31/2015 $240.00 80.00
1 4/1/2015 $333.00 111.00
1 4/2/2015 $333.00 111.00
1 4/3/2015 $429.00 143.00
1 4/4/2015 $495.00 165.00
1 4/5/2015 $341.50 136.00
1 4/6/2015 $608.00 243.00
1 4/7/2015 $504.50 202.00
1 4/8/2015 $381.00 152.00
1 4/9/2015 $480.50 192.00
1 4/10/2015 $370.00 148.00
1 4/11/2015 $503.50 201.00
1 4/12/2015 $675.00 225.00
1 4/13/2015 $504.00 168.00
1 4/14/2015 $492.00 164.00
1 4/15/2015 $368.00 123.00
1 4/16/2015 $438.00 146.00
1 4/17/2015 $357.00 119.00
1 4/18/2015 $441.00 147.00
1 4/19/2015 $792.00 264.00
1 4/20/2015 $462.00 154.00
1 4/21/2015 $387.00 129.00
1 4/22/2015 $363.00 121.00
1 4/23/2015 $357.00 119.00
1 4/24/2015 $330.00 110.00
1 4/25/2015 $417.00 139.00
1 4/26/2015 $813.00 271.00
1 4/27/2015 $576.00 192.00
1 4/28/2015 $327.00 109.00
1 4/29/2015 $315.00 105.00
1 4/30/2015 $417.00 139.00
1 5/1/2015 $441.00 147.00
1 5/2/2015 $450.00 150.00
1 5/3/2015 $791.00 264.00
1 5/4/2015 $453.00 151.00
1 5/5/2015 $408.00 136.00
1 5/6/2015 $432.00 144.00
1 5/7/2015 $438.00 146.00
1 5/8/2015 $477.00 159.00
1 5/9/2015 $501.00 167.00
1 5/10/2015 $612.00 204.00
1 5/11/2015 $549.00 183.00
1 5/12/2015 $384.00 128.00
1 5/13/2015 $453.00 151.00
1 5/14/2015 $447.00 149.00
1 5/15/2015 $372.00 124.00
1 5/16/2015 $444.00 148.00
1 5/17/2015 $884.25 295.00
1 5/18/2015 $378.00 126.00
1 5/19/2015 $387.00 129.00
1 5/20/2015 $429.00 143.00
1 5/21/2015 $462.00 154.00
1 5/22/2015 $426.00 142.00
1 5/23/2015 $480.00 160.00
1 5/24/2015 $486.00 162.00
1 5/25/2015 $549.00 183.00
1 5/26/2015 $450.00 150.00
1 5/27/2015 $378.00 126.00
1 5/28/2015 $339.00 113.00
1 5/29/2015 $348.00 116.00
1 5/30/2015 $417.00 139.00
1 5/31/2015 $696.00 232.00
1 6/1/2015 $462.00 154.00
1 6/2/2015 $357.00 119.00
1 6/3/2015 $435.00 145.00
1 6/4/2015 $315.00 105.00
1 6/5/2015 $399.00 133.00
1 6/6/2015 $495.00 165.00
1 6/7/2015 $666.00 222.00
1 6/8/2015 $438.00 146.00
1 6/9/2015 $507.00 169.00
1 6/10/2015 $399.00 133.00
1 6/11/2015 $477.00 159.00
1 6/12/2015 $402.00 134.00
1 6/13/2015 $447.00 149.00
1 6/14/2015 $552.00 184.00
1 6/15/2015 $453.00 151.00
1 6/16/2015 $360.00 120.00
1 6/17/2015 $276.00 92.00
1 6/18/2015 $348.00 116.00
1 6/19/2015 $345.00 115.00
1 6/20/2015 $441.00 147.00
1 6/21/2015 $558.00 186.00
1 6/22/2015 $435.00 145.00
1 6/23/2015 $339.00 113.00
1 6/24/2015 $384.00 128.00
1 6/25/2015 $300.00 100.00
1 6/26/2015 $336.00 112.00
1 6/27/2015 $423.00 141.00
1 6/28/2015 $576.00 192.00
1 6/29/2015 $426.00 142.00
1 6/30/2015 $294.00 98.00
1 7/1/2015 $357.00 119.00
1 7/2/2015 $423.00 141.00
1 7/3/2015 $459.00 153.00
1 7/4/2015 $381.00 127.00
1 7/5/2015 $414.00 138.00
1 7/6/2015 $396.00 132.00
1 7/7/2015 $374.00 125.00
1 7/8/2015 $297.00 99.00
1 7/9/2015 $372.00 124.00
1 7/10/2015 $387.00 129.00
1 7/11/2015 $441.00 147.00
1 7/12/2015 $594.00 198.00
1 7/13/2015 $417.00 139.00
1 7/14/2015 $369.00 123.00
1 7/15/2015 $354.00 118.00
1 7/16/2015 $396.00 132.00
1 7/17/2015 $336.00 112.00
1 7/18/2015 $465.00 155.00
1 7/19/2015 $579.00 193.00
1 7/20/2015 $390.00 130.00
1 7/21/2015 $339.00 113.00
1 7/22/2015 $282.00 94.00
1 7/23/2015 $270.00 90.00
1 7/24/2015 $348.00 116.00
1 7/25/2015 $402.00 134.00
1 7/26/2015 $705.50 282.00
1 7/27/2015 $382.00 152.00
1 7/28/2015 $353.50 141.00
1 7/29/2015 $303.50 121.00
1 7/30/2015 $383.00 153.00
1 7/31/2015 $376.50 150.00
1 8/1/2015 $412.50 165.00
1 8/2/2015 $686.00 274.00
1 8/3/2015 $413.00 165.00
1 8/4/2015 $447.50 179.00
1 8/5/2015 $340.50 136.00
1 8/6/2015 $415.00 166.00
1 8/7/2015 $474.50 189.00
1 8/8/2015 $424.00 169.00
1 8/9/2015 $547.50 183.00
1 8/10/2015 $438.00 146.00
1 8/11/2015 $345.00 115.00
1 8/12/2015 $339.00 113.00
1 8/13/2015 $357.00 119.00
1 8/14/2015 $495.00 165.00
1 8/15/2015 $438.00 146.00
1 8/16/2015 $567.00 189.00
1 8/17/2015 $474.00 158.00
1 8/18/2015 $375.00 125.00
1 8/19/2015 $369.00 123.00
1 8/20/2015 $327.00 109.00
1 8/21/2015 $324.00 108.00
1 8/22/2015 $429.00 143.00
1 8/23/2015 $759.00 253.00
1 8/24/2015 $459.00 153.00
1 8/25/2015 $387.00 129.00
1 8/26/2015 $348.00 116.00
1 8/27/2015 $276.00 92.00
1 8/28/2015 $372.00 124.00
1 8/29/2015 $474.00 158.00
1 8/30/2015 $612.00 204.00
1 8/31/2015 $429.00 143.00
1 9/1/2015 $315.00 105.00
1 9/2/2015 $312.00 104.00
1 9/3/2015 $345.00 115.00
1 9/4/2015 $453.00 151.00
1 9/5/2015 $420.00 140.00
1 9/6/2015 $368.25 123.00
1 9/7/2015 $507.00 169.00
1 9/8/2015 $375.00 125.00
1 9/9/2015 $276.00 92.00
1 9/10/2015 $291.00 97.00
1 9/11/2015 $333.00 111.00
1 9/12/2015 $534.00 178.00
1 9/13/2015 $645.00 215.00
1 9/14/2015 $435.00 145.00
1 9/15/2015 $396.00 132.00
1 9/16/2015 $282.00 94.00
1 9/17/2015 $318.00 106.00
1 9/18/2015 $291.00 97.00
1 9/19/2015 $414.00 138.00
1 9/20/2015 $600.00 200.00
1 9/21/2015 $432.00 144.00
1 9/22/2015 $291.00 97.00
1 9/23/2015 $282.00 94.00
1 9/24/2015 $275.00 92.00
1 9/25/2015 $342.00 114.00
1 9/26/2015 $402.00 134.00
1 9/27/2015 $729.00 243.00
1 9/28/2015 $423.00 141.00
1 9/29/2015 $276.00 92.00
1 9/30/2015 $261.00 87.00
1 10/1/2015 $336.00 112.00
1 10/2/2015 $285.00 95.00
1 10/3/2015 $435.00 145.00
1 10/4/2015 $642.00 214.00
1 10/5/2015 $396.00 132.00
1 10/6/2015 $366.00 122.00
1 10/7/2015 $297.00 99.00
1 10/8/2015 $294.00 98.00

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[José Augusto]

Hi

See the file Livro1.xlsx

Regards