Help with complicated situation

[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 two 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 2 10/8/2014 $348.68 92.00 2 10/9/2014 $515.44 136.00 2 10/10/2014 $496.49 131.00 2 10/11/2014 $625.35 165.00 2 10/12/2014 $780.24 206.00 2 10/13/2014 $432.06 114.00 2 10/14/2014 $473.75 125.00 2 10/15/2014 $515.44 136.00 2 10/16/2014 $481.33 127.00 2 10/17/2014 $598.82 158.00 2 10/18/2014 $825.47 218.00 2 10/19/2014 $826.22 218.00 2 10/20/2014 $397.95 105.00 2 10/21/2014 $496.09 131.00 2 10/22/2014 $439.14 116.00 2 10/23/2014 $613.63 162.00 2 10/24/2014 $606.40 160.00 2 10/25/2014 $701.15 185.00 2 10/26/2014 $674.62 178.00 2 10/27/2014 $428.27 113.00 2 10/28/2014 $492.20 130.00 2 10/29/2014 $560.92 148.00 2 10/30/2014 $394.16 104.00 2 10/31/2014 $621.01 164.00 2 11/1/2014 $678.41 179.00 2 11/2/2014 $863.22 228.00 2 11/3/2014 $447.22 118.00 2 11/4/2014 $382.79 101.00 2 11/5/2014 $420.69 111.00 2 11/6/2014 $405.18 107.00 2 11/7/2014 $413.11 109.00 2 11/8/2014 $697.01 184.00 2 11/9/2014 $792.11 209.00 2 11/10/2014 $526.81 139.00 2 11/11/2014 $495.49 131.00 2 11/12/2014 $542.91 144.00 2 11/13/2014 $544.91 144.00 2 11/14/2014 $563.96 149.00 2 11/15/2014 $778.44 206.00 2 11/16/2014 $1,111.58 370.00 2 11/17/2014 $499.74 165.00 2 11/18/2014 $614.57 203.00 2 11/19/2014 $690.20 229.00 2 11/20/2014 $841.58 280.00 2 11/21/2014 $1,081.95 360.00 2 11/22/2014 $1,662.24 553.00 2 11/23/2014 $2,287.50 760.00 2 11/24/2014 $2,369.03 788.00 2 11/25/2014 $3,324.97 1,104.00 2 11/26/2014 $2,723.16 905.00 2 11/27/2014 $1,013.69 335.00 2 11/28/2014 $567.79 189.00 2 11/29/2014 $684.16 227.00 2 11/30/2014 $583.11 154.00 2 12/1/2014 $606.40 160.00 2 12/2/2014 $439.64 116.00 2 12/3/2014 $466.17 123.00 2 12/4/2014 $541.97 143.00 2 12/5/2014 $643.35 170.00 2 12/6/2014 $814.85 215.00 2 12/7/2014 $765.08 202.00 2 12/8/2014 $688.73 182.00 2 12/9/2014 $572.29 151.00 2 12/10/2014 $480.83 127.00 2 12/11/2014 $605.90 160.00 2 12/12/2014 $738.55 195.00 2 12/13/2014 $924.76 244.00 2 12/14/2014 $897.33 237.00 2 12/15/2014 $648.09 171.00 2 12/16/2014 $678.41 179.00 2 12/17/2014 $697.36 184.00 2 12/18/2014 $811.06 214.00 2 12/19/2014 $1,071.67 283.00 2 12/20/2014 $1,586.96 419.00 2 12/21/2014 $1,909.31 504.00 2 12/22/2014 $2,417.67 638.00 2 12/23/2014 $3,732.60 985.00 2 12/24/2014 $3,956.01 1,044.00 2 12/26/2014 $916.68 242.00 2 12/27/2014 $958.87 253.00 2 12/28/2014 $943.11 249.00 2 12/29/2014 $788.32 208.00 2 12/30/2014 $1,500.64 396.00 2 12/31/2014 $2,296.39 606.00 2 1/1/2015 $791.81 209.00 2 1/2/2015 $734.76 194.00 2 1/3/2015 $689.78 182.00 2 1/4/2015 $765.58 202.00 2 1/5/2015 $447.22 118.00 2 1/6/2015 $360.05 95.00 2 1/7/2015 $526.81 139.00 2 1/8/2015 $492.70 130.00 2 1/9/2015 $670.83 177.00 2 1/10/2015 $852.75 225.00 2 1/11/2015 $909.60 240.00 2 1/12/2015 $477.54 126.00 2 1/13/2015 $560.92 148.00 2 1/14/2015 $602.61 159.00 2 1/15/2015 $541.97 143.00 2 1/16/2015 $663.05 175.00 2 1/17/2015 $742.34 196.00 2 1/18/2015 $836.74 221.00 2 1/19/2015 $628.89 166.00 2 1/20/2015 $640.01 169.00 2 1/21/2015 $424.48 112.00 2 1/22/2015 $579.87 153.00 2 1/23/2015 $974.03 257.00 2 1/24/2015 $572.29 151.00 2 1/25/2015 $1,163.13 307.00 2 1/26/2015 $428.27 113.00 2 1/27/2015 $424.48 112.00 2 1/28/2015 $598.82 158.00 2 1/29/2015 $658.71 174.00 2 1/30/2015 $882.87 233.00 2 1/31/2015 $1,620.62 428.00 2 2/1/2015 $1,413.67 373.00 2 2/2/2015 $328.73 87.00 2 2/3/2015 $484.12 128.00 2 2/4/2015 $511.65 135.00 2 2/5/2015 $488.91 129.00 2 2/6/2015 $651.88 172.00 2 2/7/2015 $822.43 217.00 2 2/8/2015 $852.75 225.00 2 2/9/2015 $477.54 126.00 2 2/10/2015 $462.38 122.00 2 2/11/2015 $621.31 164.00 2 2/12/2015 $576.08 152.00 2 2/13/2015 $739.05 195.00 2 2/14/2015 $875.49 231.00 2 2/15/2015 $644.30 170.00 2 2/16/2015 $780.74 206.00 2 2/17/2015 $420.69 111.00 2 2/18/2015 $549.55 145.00 2 2/19/2015 $481.33 127.00 2 2/20/2015 $700.90 185.00 2 2/21/2015 $788.32 208.00 2 2/22/2015 $670.83 177.00 2 2/23/2015 $504.07 133.00 2 2/24/2015 $481.33 127.00 2 2/25/2015 $534.39 141.00 2 2/26/2015 $568.50 150.00 2 2/27/2015 $572.29 151.00 2 2/28/2015 $760.79 201.00 2 3/1/2015 $670.83 177.00 2 3/2/2015 $492.70 130.00 2 3/3/2015 $704.94 186.00 2 3/4/2015 $708.48 187.00 2 3/5/2015 $348.68 92.00 2 3/6/2015 $519.23 137.00 2 3/7/2015 $761.79 201.00 2 3/8/2015 $897.98 237.00 2 3/9/2015 $576.08 152.00 2 3/10/2015 $523.02 138.00 2 3/11/2015 $432.06 114.00 2 3/12/2015 $587.45 155.00 2 3/13/2015 $670.83 177.00 2 3/14/2015 $773.16 204.00 2 3/15/2015 $735.26 194.00 2 3/16/2015 $541.97 143.00 2 3/17/2015 $523.02 138.00 2 3/18/2015 $473.75 125.00 2 3/19/2015 $549.55 145.00 2 3/20/2015 $549.55 145.00 2 3/21/2015 $761.79 201.00 2 3/22/2015 $928.55 245.00 2 3/23/2015 $454.30 120.00 2 3/24/2015 $496.49 131.00 2 3/25/2015 $553.34 146.00 2 3/26/2015 $549.55 145.00 2 3/27/2015 $602.61 159.00 2 3/28/2015 $871.20 230.00 2 3/29/2015 $1,041.93 317.00 2 3/30/2015 $600.28 182.00 2 3/31/2015 $876.64 266.00 2 4/1/2015 $1,215.22 368.00 2 4/2/2015 $1,730.60 525.00 2 4/3/2015 $3,071.37 933.00 2 4/4/2015 $3,928.68 1,192.00 2 4/5/2015 $1,771.72 468.00 2 4/6/2015 $617.77 163.00 2 4/7/2015 $515.44 136.00 2 4/8/2015 $576.08 152.00 2 4/9/2015 $613.43 162.00 2 4/10/2015 $613.98 162.00 2 4/11/2015 $845.17 223.00 2 4/12/2015 $761.09 201.00 2 4/13/2015 $602.36 159.00 2 4/14/2015 $670.83 177.00 2 4/15/2015 $564.71 149.00 2 4/16/2015 $576.08 152.00 2 4/17/2015 $718.10 190.00 2 4/18/2015 $768.87 203.00 2 4/19/2015 $905.31 239.00 2 4/20/2015 $632.18 167.00 2 4/21/2015 $523.02 138.00 2 4/22/2015 $503.57 133.00 2 4/23/2015 $564.71 149.00 2 4/24/2015 $586.50 155.00 2 4/25/2015 $598.82 158.00 2 4/26/2015 $745.63 197.00 2 4/27/2015 $629.14 166.00 2 4/28/2015 $511.65 135.00 2 4/29/2015 $477.54 126.00 2 4/30/2015 $538.18 142.00 2 5/1/2015 $680.90 180.00 2 5/2/2015 $787.77 208.00 2 5/3/2015 $874.94 231.00 2 5/4/2015 $541.77 143.00 2 5/5/2015 $439.64 116.00 2 5/6/2015 $507.86 134.00 2 5/7/2015 $488.91 129.00 2 5/8/2015 $667.04 176.00 2 5/9/2015 $829.30 220.00 2 5/10/2015 $898.23 237.00 2 5/11/2015 $544.96 144.00 2 5/12/2015 $549.05 145.00 2 5/13/2015 $504.07 133.00 2 5/14/2015 $526.81 139.00 2 5/15/2015 $525.31 139.00 2 5/16/2015 $598.82 158.00 2 5/17/2015 $807.07 213.00 2 5/18/2015 $553.34 146.00 2 5/19/2015 $595.03 157.00 2 5/20/2015 $560.42 148.00 2 5/21/2015 $572.29 151.00 2 5/22/2015 $881.87 233.00 2 5/23/2015 $913.04 241.00 2 5/24/2015 $765.58 202.00 2 5/25/2015 $729.42 193.00 2 5/26/2015 $424.48 112.00 2 5/27/2015 $534.39 141.00 2 5/28/2015 $541.52 143.00 2 5/29/2015 $526.81 139.00 2 5/30/2015 $708.73 187.00 2 5/31/2015 $640.01 169.00 2 6/1/2015 $454.80 120.00 2 6/2/2015 $481.33 127.00 2 6/3/2015 $428.27 113.00 2 6/4/2015 $576.08 152.00 2 6/5/2015 $447.22 118.00 2 6/6/2015 $735.26 194.00 2 6/7/2015 $807.27 213.00 2 6/8/2015 $485.12 128.00 2 6/9/2015 $496.49 131.00 2 6/10/2015 $534.19 141.00 2 6/11/2015 $420.69 111.00 2 6/12/2015 $515.44 136.00 2 6/13/2015 $629.14 166.00 2 6/14/2015 $670.83 177.00 2 6/15/2015 $511.65 135.00 2 6/16/2015 $458.59 121.00 2 6/17/2015 $405.53 107.00 2 6/18/2015 $454.80 120.00 2 6/19/2015 $560.37 148.00 2 6/20/2015 $663.00 175.00 2 6/21/2015 $821.93 217.00 2 6/22/2015 $454.80 120.00 2 6/23/2015 $420.69 111.00 2 6/24/2015 $496.49 131.00 2 6/25/2015 $625.35 165.00 2 6/26/2015 $583.66 154.00 2 6/27/2015 $758.00 200.00 2 6/28/2015 $727.18 192.00 2 6/29/2015 $469.96 124.00 2 6/30/2015 $499.03 132.00 2 7/1/2015 $442.93 117.00 2 7/2/2015 $666.29 176.00 2 7/3/2015 $897.73 237.00 2 7/4/2015 $746.63 197.00 2 7/5/2015 $523.02 138.00 2 7/6/2015 $500.28 132.00 2 7/7/2015 $500.28 132.00 2 7/8/2015 $500.28 132.00 2 7/9/2015 $397.95 105.00 2 7/10/2015 $575.33 152.00 2 7/11/2015 $640.51 169.00 2 7/12/2015 $689.78 182.00 2 7/13/2015 $462.38 122.00 2 7/14/2015 $447.22 118.00 2 7/15/2015 $504.07 133.00 2 7/16/2015 $462.38 122.00 2 7/17/2015 $613.98 162.00 2 7/18/2015 $708.73 187.00 2 7/19/2015 $663.25 175.00 2 7/20/2015 $507.86 134.00 2 7/21/2015 $610.19 161.00 2 7/22/2015 $538.18 142.00 2 7/23/2015 $523.02 138.00 2 7/24/2015 $495.99 131.00 2 7/25/2015 $860.33 227.00 2 7/26/2015 $727.68 192.00 2 7/27/2015 $466.17 123.00 2 7/28/2015 $488.91 129.00 2 7/29/2015 $439.64 116.00 2 7/30/2015 $469.96 124.00 2 7/31/2015 $579.87 153.00 2 8/1/2015 $583.66 154.00 2 8/2/2015 $706.23 177.00 2 8/3/2015 $542.39 136.00 2 8/4/2015 $454.86 114.00 2 8/5/2015 $498.75 125.00 2 8/6/2015 $498.75 125.00 2 8/7/2015 $709.22 178.00 2 8/8/2015 $602.49 151.00 2 8/9/2015 $765.08 192.00 2 8/10/2015 $534.36 134.00 2 8/11/2015 $622.44 156.00 2 8/12/2015 $522.69 131.00 2 8/13/2015 $490.02 123.00 2 8/14/2015 $662.34 166.00 2 8/15/2015 $546.63 137.00 2 8/16/2015 $714.21 179.00 2 8/17/2015 $359.10 90.00 2 8/18/2015 $546.63 137.00 2 8/19/2015 $422.94 106.00 2 8/20/2015 $578.05 145.00 2 8/21/2015 $673.36 169.00 2 8/22/2015 $662.34 166.00 2 8/23/2015 $798.00 200.00 2 8/24/2015 $594.51 149.00 2 8/25/2015 $541.89 136.00 2 8/26/2015 $530.17 133.00 2 8/27/2015 $466.83 117.00 2 8/28/2015 $570.57 143.00 2 8/29/2015 $789.52 198.00 2 8/30/2015 $791.01 199.00 2 8/31/2015 $530.67 133.00 2 9/1/2015 $550.62 138.00 2 9/2/2015 $514.71 129.00 2 9/3/2015 $630.42 158.00 2 9/4/2015 $861.84 216.00 2 9/5/2015 $921.69 231.00 2 9/6/2015 $913.71 229.00 2 9/7/2015 $833.91 209.00 2 9/8/2015 $574.56 144.00 2 9/9/2015 $518.70 130.00 2 9/10/2015 $514.71 129.00 2 9/11/2015 $562.59 141.00 2 9/12/2015 $821.94 206.00 2 9/13/2015 $901.74 226.00 2 9/14/2015 $642.39 161.00 2 9/15/2015 $474.81 119.00 2 9/16/2015 $558.60 140.00 2 9/17/2015 $593.76 149.00 2 9/18/2015 $717.45 180.00 2 9/19/2015 $868.32 218.00 2 9/20/2015 $1,129.17 283.00 2 9/21/2015 $490.77 123.00 2 9/22/2015 $514.71 129.00 2 9/23/2015 $574.56 144.00 2 9/24/2015 $486.78 122.00 2 9/25/2015 $713.76 179.00 2 9/26/2015 $853.86 214.00 2 9/27/2015 $790.02 198.00 2 9/28/2015 $542.64 136.00 2 9/29/2015 $622.44 156.00 2 9/30/2015 $554.61 139.00 2 10/1/2015 $578.55 145.00 2 10/2/2015 $642.39 161.00 2 10/3/2015 $849.87 213.00 2 10/4/2015 $853.86 214.00 2 10/5/2015 $598.50 150.00 2 10/6/2015 $526.68 132.00 2 10/7/2015 $590.52 148.00 2 10/8/2015 $618.45 155.00 <tbody> </tbody>

<tbody>
</tbody>

 

[oldbrewer]

Code	Sales Day	Dollars	Units
1	10/08/2014	$363.00	121									01/01/2014	0
1	11/08/2014	$312.00	104									29/01/2014	0
1	12/08/2014	$360.00	120									26/02/2014	0
1	13/08/2014	$453.00	151									26/03/2014	0
1	14/08/2014	$585.00	195									23/04/2014	0
1	15/08/2014	$411.00	137									21/05/2014	0
1	16/08/2014	$462.00	154									18/06/2014	0
1	17/08/2014	$375.00	125									16/07/2014	345
1	18/08/2014	$288.00	96									13/08/2014	3773
1	19/08/2014	$369.00	123									10/09/2014	4298
1	20/08/2014	$456.00	152									08/10/2014	3831
1	21/08/2014	$621.00	207									05/11/2014	3931
1	22/08/2014	$414.00	138									03/12/2014	3704
1	23/08/2014	$390.00	130									31/12/2014	3941
1	24/08/2014	$276.00	92									28/01/2015	4372
1	25/08/2014	$324.00	108									25/02/2015	4516
1	26/08/2014	$330.00	110									25/03/2015	4079
1	27/08/2014	$408.00	136									22/04/2015	3768
1	28/08/2014	$645.00	215									20/05/2015	4299
1	29/08/2014	$453.00	151									17/06/2015	3837
1	30/08/2014	$336.00	112									15/07/2015	3610
1	31/08/2014	$312.00	104									12/08/2015	4138
1	01/09/2014	$288.00	96									09/09/2015	8579
1	02/09/2014	$339.00	113									07/10/2015	769
1	03/09/2014	$447.00	149									04/11/2015	0
1	04/09/2014	$588.00	196									02/12/2015	0
1	05/09/2014	$405.00	135									30/12/2015	0
1	06/09/2014	$372.00	124
1	07/09/2014	$306.00	102
1	08/09/2014	$321.00	107								formula in N2 (0)
1	09/09/2014	$345.00	115
1	10/09/2014	$396.00	132							=SUMPRODUCT(($B$2:$B$428>=M2)*($B$2:$B$428<M3)*($D$2:$D$428))
1	11/09/2014	$788.00	315
1	12/09/2014	$500.50	200
1	13/09/2014	$413.00	164
1	14/09/2014	$489.00	195
1	15/09/2014	$443.00	177					note I changed the dates as you had a mixture
1	16/09/2014	$413.50	165					of dates and text
1	17/09/2014	$514.00	205
1	18/09/2014	$708.00	236					note 2 at present this is for any code
1	19/09/2014	$498.00	166					easy to break down by code also
1	20/09/2014	$357.00	119
1	21/09/2014	$324.00	108					will do this if approach ok
1	22/09/2014	$378.00	126
1	23/09/2014	$420.00	140
1	24/09/2014	$498.00	166
1	25/09/2014	$612.00	204
1	26/09/2014	$474.00	158
1	27/09/2014	$527.25	176
1	28/09/2014	$300.00	100
1	29/09/2014	$33.00	11
1	30/09/2014	$294.00	98
1	01/10/2014	$357.00	119
1	02/10/2014	$576.00	192
1	03/10/2014	$429.00	143
1	04/10/2014	$369.00	123
1	05/10/2014	$366.00	122
1	06/10/2014	$273.00	91
1	07/10/2014	$441.00	147
1	08/10/2014	$489.00	163
1	09/10/2014	$600.00	200
1	10/10/2014	$591.00	197
1	11/10/2014	$378.00	126
1	12/10/2014	$363.00	121
1	13/10/2014	$360.00	120
1	14/10/2014	$408.00	136
1	15/10/2014	$429.00	143
1	16/10/2014	$792.00	264
1	17/10/2014	$354.00	118
1	18/10/2014	$282.00	94
1	19/10/2014	$315.00	105
1	20/10/2014	$357.00	119
1	21/10/2014	$351.00	117
1	22/10/2014	$351.00	117
1	23/10/2014	$630.00	210
1	24/10/2014	$357.00	119
1	25/10/2014	$363.00	121
1	26/10/2014	$393.00	131
1	27/10/2014	$294.00	98
1	28/10/2014	$387.00	129
1	29/10/2014	$474.00	158
1	30/10/2014	$420.00	140
1	31/10/2014	$348.00	116
1	01/11/2014	$384.00	128
1	02/11/2014	$186.00	62
1	03/11/2014	$414.00	138
1	04/11/2014	$423.00	141
1	05/11/2014	$681.00	227
1	06/11/2014	$429.00	143
1	07/11/2014	$282.00	94
1	08/11/2014	$342.00	114
1	09/11/2014	$420.00	140
1	10/11/2014	$426.00	142
1	11/11/2014	$573.00	191
1	12/11/2014	$789.00	263
1	13/11/2014	$366.00	122
1	14/11/2014	$276.00	92
1	15/11/2014	$321.00	107
1	16/11/2014	$375.00	125
1	17/11/2014	$357.00	119
1	18/11/2014	$408.00	136
1	19/11/2014	$573.00	191
1	20/11/2014	$474.00	158
1	21/11/2014	$393.00	131
1	22/11/2014	$243.00	81
1	23/11/2014	$279.00	93
1	24/11/2014	$567.00	189
1	25/11/2014	$363.00	121
1	26/11/2014	$777.00	259
1	27/11/2014	$213.00	71
1	28/11/2014	$267.00	89
1	29/11/2014	$285.00	95
1	30/11/2014	$312.00	104
1	01/12/2014	$360.00	120
1	02/12/2014	$642.00	214
1	03/12/2014	$612.00	204
1	04/12/2014	$285.00	95
1	05/12/2014	$324.00	108
1	06/12/2014	$291.00	97
1	07/12/2014	$366.00	122
1	08/12/2014	$405.00	135
1	09/12/2014	$384.00	128
1	10/12/2014	$648.00	216
1	11/12/2014	$414.00	138
1	12/12/2014	$333.00	111
1	13/12/2014	$324.00	108
1	14/12/2014	$351.00	117
1	15/12/2014	$351.00	117
1	16/12/2014	$393.00	131
1	17/12/2014	$417.00	139
1	18/12/2014	$534.00	178
1	19/12/2014	$270.00	90
1	20/12/2014	$327.00	109
1	21/12/2014	$288.00	96
1	22/12/2014	$441.00	147
1	23/12/2014	$621.00	207
1	24/12/2014	$537.00	179
1	25/12/2014	$420.00	140
1	26/12/2014	$297.00	99
1	27/12/2014	$303.00	101
1	28/12/2014	$321.00	107
1	29/12/2014	$336.00	112
1	30/12/2014	$519.00	173
1	31/12/2014	$683.00	228
1	01/01/2015	$498.00	166
1	02/01/2015	$441.00	147
1	03/01/2015	$519.00	173
1	04/01/2015	$219.00	73
1	05/01/2015	$366.00	122
1	06/01/2015	$423.00	141
1	07/01/2015	$720.00	240
1	08/01/2015	$438.00	146
1	09/01/2015	$357.00	119
1	10/01/2015	$426.00	142
1	11/01/2015	$387.00	129
1	12/01/2015	$378.00	126
1	13/01/2015	$465.00	155
1	14/01/2015	$696.00	232
1	15/01/2015	$369.00	123
1	16/01/2015	$363.00	121
1	17/01/2015	$249.00	83
1	18/01/2015	$384.00	128
1	19/01/2015	$291.00	97
1	20/01/2015	$396.00	132
1	21/01/2015	$633.00	211
1	22/01/2015	$438.00	146
1	23/01/2015	$312.00	104
1	24/01/2015	$297.00	99
1	25/01/2015	$333.00	111
1	26/01/2015	$285.00	95
1	27/01/2015	$456.00	152
1	28/01/2015	$732.00	244
1	29/01/2015	$348.00	116
1	30/01/2015	$240.00	80
1	31/01/2015	$333.00	111
1	01/02/2015	$333.00	111
1	02/02/2015	$429.00	143
1	03/02/2015	$495.00	165
1	04/02/2015	$341.50	136
1	05/02/2015	$608.00	243
1	06/02/2015	$504.50	202
1	07/02/2015	$381.00	152
1	08/02/2015	$480.50	192
1	09/02/2015	$370.00	148
1	10/02/2015	$503.50	201
1	11/02/2015	$675.00	225
1	12/02/2015	$504.00	168
1	13/02/2015	$492.00	164
1	14/02/2015	$368.00	123
1	15/02/2015	$438.00	146
1	16/02/2015	$357.00	119
1	17/02/2015	$441.00	147
1	18/02/2015	$792.00	264
1	19/02/2015	$462.00	154
1	20/02/2015	$387.00	129
1	21/02/2015	$363.00	121
1	22/02/2015	$357.00	119
1	23/02/2015	$330.00	110
1	24/02/2015	$417.00	139
1	25/02/2015	$813.00	271
1	26/02/2015	$576.00	192
1	27/02/2015	$327.00	109
1	28/02/2015	$315.00	105
1	01/03/2015	$417.00	139
1	02/03/2015	$441.00	147
1	03/03/2015	$450.00	150
1	04/03/2015	$791.00	264
1	05/03/2015	$453.00	151
1	06/03/2015	$408.00	136
1	07/03/2015	$432.00	144
1	08/03/2015	$438.00	146
1	09/03/2015	$477.00	159
1	10/03/2015	$501.00	167
1	11/03/2015	$612.00	204
1	12/03/2015	$549.00	183
1	13/03/2015	$384.00	128
1	14/03/2015	$453.00	151
1	15/03/2015	$447.00	149
1	16/03/2015	$372.00	124
1	17/03/2015	$444.00	148
1	18/03/2015	$884.25	295
1	19/03/2015	$378.00	126
1	20/03/2015	$387.00	129
1	21/03/2015	$429.00	143
1	22/03/2015	$462.00	154
1	23/03/2015	$426.00	142
1	24/03/2015	$480.00	160
1	25/03/2015	$486.00	162
1	26/03/2015	$549.00	183
1	27/03/2015	$450.00	150
1	28/03/2015	$378.00	126
1	29/03/2015	$339.00	113
1	30/03/2015	$348.00	116
1	31/03/2015	$417.00	139
1	01/04/2015	$696.00	232
1	02/04/2015	$462.00	154
1	03/04/2015	$357.00	119
1	04/04/2015	$435.00	145
1	05/04/2015	$315.00	105
1	06/04/2015	$399.00	133
1	07/04/2015	$495.00	165
1	08/04/2015	$666.00	222
1	09/04/2015	$438.00	146
1	10/04/2015	$507.00	169
1	11/04/2015	$399.00	133
1	12/04/2015	$477.00	159
1	13/04/2015	$402.00	134
1	14/04/2015	$447.00	149
1	15/04/2015	$552.00	184
1	16/04/2015	$453.00	151
1	17/04/2015	$360.00	120
1	18/04/2015	$276.00	92
1	19/04/2015	$348.00	116
1	20/04/2015	$345.00	115
1	21/04/2015	$441.00	147
1	22/04/2015	$558.00	186
1	23/04/2015	$435.00	145
1	24/04/2015	$339.00	113
1	25/04/2015	$384.00	128
1	26/04/2015	$300.00	100
1	27/04/2015	$336.00	112
1	28/04/2015	$423.00	141
1	29/04/2015	$576.00	192
1	30/04/2015	$426.00	142
1	01/05/2015	$294.00	98
1	02/05/2015	$357.00	119
1	03/05/2015	$423.00	141
1	04/05/2015	$459.00	153
1	05/05/2015	$381.00	127
1	06/05/2015	$414.00	138
1	07/05/2015	$396.00	132
1	08/05/2015	$374.00	125
1	09/05/2015	$297.00	99
1	10/05/2015	$372.00	124
1	11/05/2015	$387.00	129
1	12/05/2015	$441.00	147
1	13/05/2015	$594.00	198
1	14/05/2015	$417.00	139
1	15/05/2015	$369.00	123
1	16/05/2015	$354.00	118
1	17/05/2015	$396.00	132
1	18/05/2015	$336.00	112
1	19/05/2015	$465.00	155
1	20/05/2015	$579.00	193
1	21/05/2015	$390.00	130
1	22/05/2015	$339.00	113
1	23/05/2015	$282.00	94
1	24/05/2015	$270.00	90
1	25/05/2015	$348.00	116
1	26/05/2015	$402.00	134
1	27/05/2015	$705.50	282
1	28/05/2015	$382.00	152
1	29/05/2015	$353.50	141
1	30/05/2015	$303.50	121
1	31/05/2015	$383.00	153
1	01/06/2015	$376.50	150
1	02/06/2015	$412.50	165
1	03/06/2015	$686.00	274
1	04/06/2015	$413.00	165
1	05/06/2015	$447.50	179
1	06/06/2015	$340.50	136
1	07/06/2015	$415.00	166
1	08/06/2015	$474.50	189
1	09/06/2015	$424.00	169
1	10/06/2015	$547.50	183
1	11/06/2015	$438.00	146
1	12/06/2015	$345.00	115
1	13/06/2015	$339.00	113
1	14/06/2015	$357.00	119
1	15/06/2015	$495.00	165
1	16/06/2015	$438.00	146
1	17/06/2015	$567.00	189
1	18/06/2015	$474.00	158
1	19/06/2015	$375.00	125
1	20/06/2015	$369.00	123
1	21/06/2015	$327.00	109
1	22/06/2015	$324.00	108
1	23/06/2015	$429.00	143
1	24/06/2015	$759.00	253
1	25/06/2015	$459.00	153
1	26/06/2015	$387.00	129
1	27/06/2015	$348.00	116
1	28/06/2015	$276.00	92
1	29/06/2015	$372.00	124
1	30/06/2015	$474.00	158
1	01/07/2015	$612.00	204
1	02/07/2015	$429.00	143
1	03/07/2015	$315.00	105
1	04/07/2015	$312.00	104
1	05/07/2015	$345.00	115
1	06/07/2015	$453.00	151
1	07/07/2015	$420.00	140
1	08/07/2015	$368.25	123
1	09/07/2015	$507.00	169
1	10/07/2015	$375.00	125
1	11/07/2015	$276.00	92
1	12/07/2015	$291.00	97
1	13/07/2015	$333.00	111
1	14/07/2015	$534.00	178
1	15/07/2015	$645.00	215
1	16/07/2015	$435.00	145
1	17/07/2015	$396.00	132
1	18/07/2015	$282.00	94
1	19/07/2015	$318.00	106
1	20/07/2015	$291.00	97
1	21/07/2015	$414.00	138
1	22/07/2015	$600.00	200
1	23/07/2015	$432.00	144
1	24/07/2015	$291.00	97
1	25/07/2015	$282.00	94
1	26/07/2015	$275.00	92
1	27/07/2015	$342.00	114
1	28/07/2015	$402.00	134
1	29/07/2015	$729.00	243
1	30/07/2015	$423.00	141
1	31/07/2015	$276.00	92
1	01/08/2015	$261.00	87
1	02/08/2015	$336.00	112
1	03/08/2015	$285.00	95
1	04/08/2015	$435.00	145
1	05/08/2015	$642.00	214
1	06/08/2015	$396.00	132
1	07/08/2015	$366.00	122
1	08/08/2015	$297.00	99
1	09/08/2015	$294.00	98
2	10/08/2015	$348.68	92
2	11/08/2015	$515.44	136
2	12/08/2015	$496.49	131
2	13/08/2015	$625.35	165
2	14/08/2015	$780.24	206
2	15/08/2015	$432.06	114
2	16/08/2015	$473.75	125
2	17/08/2015	$515.44	136
2	18/08/2015	$481.33	127
2	19/08/2015	$598.82	158
2	20/08/2015	$825.47	218
2	21/08/2015	$826.22	218
2	22/08/2015	$397.95	105
2	23/08/2015	$496.09	131
2	24/08/2015	$439.14	116
2	25/08/2015	$613.63	162
2	26/08/2015	$606.40	160
2	27/08/2015	$701.15	185
2	28/08/2015	$674.62	178
2	29/08/2015	$428.27	113
2	30/08/2015	$492.20	130
2	31/08/2015	$560.92	148
2	01/09/2015	$394.16	104
2	02/09/2015	$621.01	164
2	03/09/2015	$678.41	179
2	04/09/2015	$863.22	228
2	05/09/2015	$447.22	118
2	06/09/2015	$382.79	101
2	07/09/2015	$420.69	111
2	08/09/2015	$405.18	107
2	09/09/2015	$413.11	109
2	10/09/2015	$697.01	184
2	11/09/2015	$792.11	209
2	12/09/2015	$526.81	139
2	13/09/2015	$495.49	131
2	14/09/2015	$542.91	144
2	15/09/2015	$544.91	144
2	16/09/2015	$563.96	149
2	17/09/2015	$778.44	206
2	18/09/2015	$1,111.58	370
2	19/09/2015	$499.74	165
2	20/09/2015	$614.57	203
2	21/09/2015	$690.20	229
2	22/09/2015	$841.58	280
2	23/09/2015	$1,081.95	360
2	24/09/2015	$1,662.24	553
2	25/09/2015	$2,287.50	760
2	26/09/2015	$2,369.03	788
2	27/09/2015	$3,324.97	1,104.00
2	28/09/2015	$2,723.16	905
2	29/09/2015	$1,013.69	335
2	30/09/2015	$567.79	189
2	01/10/2015	$684.16	227
2	02/10/2015	$583.11	154
2	03/10/2015	$606.40	160
2	04/10/2015	$439.64	116
2	05/10/2015	$466.17	123
2	06/10/2015	$541.97	143
2	07/10/2015	$643.35	170
2	08/10/2015	$814.85	215
2	09/10/2015	$765.08	202
2	10/10/2015	$688.73	182

<colgroup><col><col><col><col span="3"><col><col span="5"><col><col span="4"></colgroup><tbody>
</tbody>

 

[pjmorris]

Hi,

In cell E1, enter 8 Oct 14.
In cell E2, enter this formula: =IF(1+INT((B2-$F$1)/28)=14,13,1+INT((B2-$F$1)/28)) and copy down your entire list.

This will put a 'period' number next to each entry that updates every 28 days. Note that for the 365 day of the year the answer is forced to be 13, which is why I've used an IF function rather than just 1+INT((B2-$F$1)/28 which gives 14 for that day.

Next, insert a pivot table, use Code as the Row label, use Period as the Column Label (note this will show as 8 Oct 14), then use Dollars as the Values. You will then get a table with all your codes and the amounts for each period.

I have no idea how long this will take to run over 17 million entries though - seems unlikely to be quick!

HTH

 

[oldbrewer]

whereas my sumproduct way is pretty quick

 

[pjmorris]

Only if you can read it? I've only just realised that its buried in the middle of the second post!

And having posted, I find that the Pivot table on the 750,000 sample I managed to test is actually pretty quick.

 

[oldbrewer]

Peter - It is your data that makes the post so big. It would be a bit insulting if I typed "scroll over to the right" to see the output and formulas.....

And I didn't say a pivot table was slow. If speed becomes an issue fine tuning may be necessary.

 

[pjmorris]

Oldbrewer, no problem, but your post is buried in the middle of a set of data - I haven't posted any data, I wonder whether our browsers are showing the same thing? I agree that getting people to scroll etc is a bit rude.

All I can see of your sumproduct is: SUMPRODUCT(($B$2:$B$428>=M2)*($B$2:$B$428 which is obviously incomplete.

Confused of Devon.

PS. It would be nice if the original OP commented on either of our suggestions!

Regards

 

[oldbrewer]

Date	Time	hut1	hut2	hut3				hut1	hut2	hut3									ROW1
31/08/2015	00:02	30,973.00	60,785.00	8,431.00			31/08/2015	n/a	n/a	n/a									ROW2
01/09/2015	00:02	31,262.00	61,136.00	8,549.00			01/09/2015	289	351	118									ROW3
02/09/2015	00:02	31,550.00	61,486.00	8,666.00			02/09/2015	288	350	117									ROW4
03/09/2015	00:02	31,837.00	61,835.00	8,782.00			03/09/2015	287	349	116									ROW5
04/09/2015	00:02	32,123.00	62,183.00	8,897.00			04/09/2015	286	348	115									ROW6
05/09/2015	00:02	32,408.00	62,530.00	9,011.00			05/09/2015	285	347	114									ROW7
06/09/2015	00:02	32,692.00	62,876.00	9,124.00			06/09/2015	284	346	113				hut1	hut2	hut3			ROW8
07/09/2015	00:02	32,975.00	63,221.00	9,236.00			07/09/2015	283	345	112		N9>>>>>>	01/09/2015	8228	10171	3071			ROW9
08/09/2015	00:02	33,257.00	63,565.00	9,347.00			08/09/2015	282	344	111		N10>>>>>	01/10/2015						ROW10
09/09/2015	00:02	33,538.00	63,908.00	9,457.00			09/09/2015	281	343	110									ROW11
10/09/2015	00:02	33,818.00	64,250.00	9,566.00			10/09/2015	280	342	109									ROW12
11/09/2015	00:02	34,097.00	64,591.00	9,674.00			11/09/2015	279	341	108		8228 calculated by						ROW13
12/09/2015	00:02	34,375.00	64,931.00	9,781.00			12/09/2015	278	340	107									ROW14
13/09/2015	00:02	34,652.00	65,270.00	9,887.00			13/09/2015	277	339	106		=SUMPRODUCT(($H$3:$H$39>=$N9)*($H$3:$H$39<$N10)*($I$3:$I$39))	ROW15
14/09/2015	00:02	34,928.00	65,608.00	9,992.00			14/09/2015	276	338	105									ROW16
15/09/2015	00:02	35,203.00	65,945.00	10,096.00			15/09/2015	275	337	104									ROW17
16/09/2015	00:02	35,477.00	66,281.00	10,199.00			16/09/2015	274	336	103									ROW18
17/09/2015	00:02	35,750.00	66,616.00	10,301.00			17/09/2015	273	335	102		the right hand table now autopopulates				ROW19
18/09/2015	00:02	36,022.00	66,950.00	10,402.00			18/09/2015	272	334	101		as you add new data to the left hand table				ROW20
19/09/2015	00:02	36,293.00	67,283.00	10,502.00			19/09/2015	271	333	100									ROW21
20/09/2015	00:02	36,563.00	67,615.00	10,601.00			20/09/2015	270	332	99									ROW22
21/09/2015	00:02	36,832.00	67,946.00	10,699.00			21/09/2015	269	331	98		the formula in the empty cell to the left				ROW23
22/09/2015	00:02	37,100.00	68,276.00	10,796.00			22/09/2015	268	330	97		of the cell marked ###### is					ROW24
23/09/2015	00:02	37,367.00	68,605.00	10,892.00			23/09/2015	267	329	96									ROW25
24/09/2015	00:02	37,633.00	68,933.00	10,987.00			24/09/2015	266	328	95		=IF($H40="","",E40-E39)					ROW26
25/09/2015	00:02	37,898.00	69,260.00	11,081.00			25/09/2015	265	327	94									ROW27
26/09/2015	00:02	38,162.00	69,586.00	11,174.00			26/09/2015	264	326	93		H40 will only fill if A40 is not blank				ROW28
27/09/2015	00:02	38,425.00	69,911.00	11,266.00			27/09/2015	263	325	92									ROW29
28/09/2015	00:02	38,683.00	70,259.00	11,345.00			28/09/2015	258	348	79									ROW30
29/09/2015	00:02	38,943.00	70,605.00	11,423.00			29/09/2015	260	346	78									ROW31
30/09/2015	00:02	39,201.00	70,956.00	11,502.00			30/09/2015	258	351	79									ROW32
01/10/2015	00:02	39,463.00	71,302.00	11,580.00			01/10/2015	262	346	78									ROW33
02/10/2015	00:02	39,723.00	71,643.00	11,659.00			02/10/2015	260	341	79									ROW34
03/10/2015	00:02	39,986.00	71,983.00	11,737.00			03/10/2015	263	340	78									ROW35
04/10/2015	00:02	40,247.00	72,312.00	11,816.00			04/10/2015	261	329	79									ROW36
05/10/2015	00:02	40,510.00	72,638.00	11,894.00			05/10/2015	263	326	78									ROW37
06/10/2015	00:02	40,773.00	72,960.00	11,973.00			06/10/2015	263	322	79									ROW38
07/10/2015	00:02	41,023.00	73,272.00	12,051.00			07/10/2015	250	312	78									ROW39
						H40>>>>					#####								ROW40
																			ROW41
																			ROW42
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T

<colgroup><col><col><col span="3"><col><col><col><col><col><col><col span="2"><col><col span="6"></colgroup><tbody>
</tbody>

 

[oldbrewer]

I think I didnt copy it properly the above seems ok

 

[oldbrewer]

please ignore last 2 posts I am having a bad day..........