Spreadsheet: 329869d1404439082-conditional-sum-sumproduct
Sheet: Sheet1

Date | Value
2014-01-01 00:00:00 | 0 |  | 2014-06-01 00:00:00 |  |  |  |  | Total
2014-01-02 00:00:00 | 0 |  | Weekly Totals
2014-01-03 00:00:00 | 0
2014-01-04 00:00:00 | 4396.940625
2014-01-05 00:00:00 | 4625.998125
2014-01-06 00:00:00 | 8806.809375
2014-01-07 00:00:00 | 6933.609375
2014-01-08 00:00:00 | 16258.948125
2014-01-09 00:00:00 | 14122.5525
2014-01-10 00:00:00 | 31241.660625
2014-01-11 00:00:00 | 26993.728125
2014-01-12 00:00:00 | 11423.724375
2014-01-13 00:00:00 | 18563.278125
2014-01-14 00:00:00 | 19702.7775
2014-01-15 00:00:00 | 22540.41562499999
2014-01-16 00:00:00 | 21192.163125
2014-01-17 00:00:00 | 31422.995625
2014-01-18 00:00:00 | 27669.403125
2014-01-19 00:00:00 | 10990.704375
2014-01-20 00:00:00 | 22533.38062500001
2014-01-21 00:00:00 | 16996.179375
2014-01-22 00:00:00 | 22284.163125
2014-01-23 00:00:00 | 17862.744375
2014-01-24 00:00:00 | 31789.865625
2014-01-25 00:00:00 | 28279.2825
2014-01-26 00:00:00 | 13701.2925
2014-01-27 00:00:00 | 12291.2475
2014-01-28 00:00:00 | 18509.885625
2014-01-29 00:00:00 | 21225.46125
2014-01-30 00:00:00 | 27134.86125
2014-01-31 00:00:00 | 53340.81375000001
2014-02-01 00:00:00 | 29487.64875
2014-02-02 00:00:00 | 10443.3525
2014-02-03 00:00:00 | 20443.355625
2014-02-04 00:00:00 | 21366.31875
2014-02-05 00:00:00 | 25973.5875
2014-02-06 00:00:00 | 36928.854375
2014-02-07 00:00:00 | 46849.753125
2014-02-08 00:00:00 | 35602.74375
2014-02-09 00:00:00 | 20943.759375
2014-02-10 00:00:00 | 23784.31125
2014-02-11 00:00:00 | 37512.615
2014-02-12 00:00:00 | 33517.155
2014-02-13 00:00:00 | 32843.44875
2014-02-14 00:00:00 | 50590.955625
2014-02-15 00:00:00 | 37153.48875
2014-02-16 00:00:00 | 11926.543125
2014-02-17 00:00:00 | 23802.68625
2014-02-18 00:00:00 | 28155.225
2014-02-19 00:00:00 | 37113.759375
2014-02-20 00:00:00 | 31211.263125
2014-02-21 00:00:00 | 47459.488125
2014-02-22 00:00:00 | 33304.175625
2014-02-23 00:00:00 | 12566.95125
2014-02-24 00:00:00 | 24709.610625
2014-02-25 00:00:00 | 27511.640625
2014-02-26 00:00:00 | 36731.21812500001
2014-02-27 00:00:00 | 38404.66875
2014-02-28 00:00:00 | 44533.57125000001
2014-03-01 00:00:00 | 34286.31937500001
2014-03-02 00:00:00 | 8738.848125
2014-03-03 00:00:00 | 21428.413125
2014-03-04 00:00:00 | 22489.201875
2014-03-05 00:00:00 | 31093.715625
2014-03-06 00:00:00 | 36734.184375
2014-03-07 00:00:00 | 45973.22625000001
2014-03-08 00:00:00 | 31831.681875
2014-03-09 00:00:00 | 12560.625
2014-03-10 00:00:00 | 27817.965
2014-03-11 00:00:00 | 29301.6675
2014-03-12 00:00:00 | 28573.085625
2014-03-13 00:00:00 | 29896.51875
2014-03-14 00:00:00 | 38292.961875
2014-03-15 00:00:00 | 29135.885625
2014-03-16 00:00:00 | 10352.08125
2014-03-17 00:00:00 | 20553.605625
2014-03-18 00:00:00 | 25315.84125
2014-03-19 00:00:00 | 34188.49875
2014-03-20 00:00:00 | 34286.39812500001
2014-03-21 00:00:00 | 44519.488125
2014-03-22 00:00:00 | 33876.39937500001
2014-03-23 00:00:00 | 21281.045625
2014-03-24 00:00:00 | 13577.746875
2014-03-25 00:00:00 | 27322.23375
2014-03-26 00:00:00 | 29265.770625
2014-03-27 00:00:00 | 32368.336875
2014-03-28 00:00:00 | 33238.45875
2014-03-29 00:00:00 | 30788.401875
2014-03-30 00:00:00 | 9599.1525
2014-03-31 00:00:00 | 17830.785
2014-04-01 00:00:00 | 22752.84375
2014-04-02 00:00:00 | 27449.28375
2014-04-03 00:00:00 | 31134.915
2014-04-04 00:00:00 | 39536.8575
2014-04-05 00:00:00 | 29296.535625
2014-04-06 00:00:00 | 9329.551875
2014-04-07 00:00:00 | 15119.97375
2014-04-08 00:00:00 | 25591.2825
2014-04-09 00:00:00 | 30748.816875
2014-04-10 00:00:00 | 29908.38375
2014-04-11 00:00:00 | 46025.96250000001
2014-04-12 00:00:00 | 26581.340625
2014-04-13 00:00:00 | 9402.789375
2014-04-14 00:00:00 | 21799.05000000001
2014-04-15 00:00:00 | 25766.855625
2014-04-16 00:00:00 | 29469.3
2014-04-17 00:00:00 | 28563.36
2014-04-18 00:00:00 | 37290.14625000001
2014-04-19 00:00:00 | 28596.973125
2014-04-20 00:00:00 | 12208.258125
2014-04-21 00:00:00 | 14449.49625
2014-04-22 00:00:00 | 23674.520625
2014-04-23 00:00:00 | 22343.58
2014-04-24 00:00:00 | 26802.58875
2014-04-25 00:00:00 | 53840.233125
2014-04-26 00:00:00 | 36906.148125
2014-04-27 00:00:00 | 9647.741250000001
2014-04-28 00:00:00 | 25423.111875
2014-04-29 00:00:00 | 32843.63250000001
2014-04-30 00:00:00 | 40777.52437500001
2014-05-01 00:00:00 | 33229.2975
2014-05-02 00:00:00 | 49974.30375000001
2014-05-03 00:00:00 | 32783.12625
2014-05-04 00:00:00 | 24884.06812500001
2014-05-05 00:00:00 | 22696.681875
2014-05-06 00:00:00 | 20157.76875
2014-05-07 00:00:00 | 33085.171875
2014-05-08 00:00:00 | 36690.15
2014-05-09 00:00:00 | 44301.67875
2014-05-10 00:00:00 | 39117.736875
2014-05-11 00:00:00 | 17493.511875
2014-05-12 00:00:00 | 19572.695625
2014-05-13 00:00:00 | 25500.72
2014-05-14 00:00:00 | 33228.470625
2014-05-15 00:00:00 | 37641.620625
2014-05-16 00:00:00 | 49319.93062499999
2014-05-17 00:00:00 | 35928.61125
2014-05-18 00:00:00 | 12229.7175
2014-05-19 00:00:00 | 17280.204375
2014-05-20 00:00:00 | 31662.25125
2014-05-21 00:00:00 | 37432.30312500001
2014-05-22 00:00:00 | 38573.836875
2014-05-23 00:00:00 | 48596.625
2014-05-24 00:00:00 | 37012.36875000001
2014-05-25 00:00:00 | 13365.489375
2014-05-26 00:00:00 | 26223.9075
2014-05-27 00:00:00 | 23424.594375
2014-05-28 00:00:00 | 35230.715625
2014-05-29 00:00:00 | 45246.376875
2014-05-30 00:00:00 | 49269.14999999999
2014-05-31 00:00:00 | 36226.771875
2014-06-01 00:00:00 | 17180.75625
2014-06-02 00:00:00 | 18556.794375
2014-06-03 00:00:00 | 24568.7925
2014-06-04 00:00:00 | 34892.83875
2014-06-05 00:00:00 | 39962.22562500001
2014-06-06 00:00:00 | 43589.89687500001
2014-06-07 00:00:00 | 28592.064375
2014-06-08 00:00:00 | 24938.169375
2014-06-09 00:00:00 | 12876.819375
2014-06-10 00:00:00 | 24826.96125
2014-06-11 00:00:00 | 24589.543125
2014-06-12 00:00:00 | 35862.343125
2014-06-13 00:00:00 | 51232.138125
2014-06-14 00:00:00 | 36053.154375
2014-06-15 00:00:00 | 14734.321875
2014-06-16 00:00:00 | 18943.535625
2014-06-17 00:00:00 | 28670.053125
2014-06-18 00:00:00 | 33361.50562500001
2014-06-19 00:00:00 | 45301.33125
2014-06-20 00:00:00 | 44460.08437500001
2014-06-21 00:00:00 | 32981.300625
2014-06-22 00:00:00 | 9161.919375000001
2014-06-23 00:00:00 | 21188.60625
2014-06-24 00:00:00 | 23289.23625
2014-06-25 00:00:00 | 28951.190625
2014-06-26 00:00:00 | 37989.18375
2014-06-27 00:00:00 | 53043.1125
2014-06-28 00:00:00 | 32357.50875
2014-06-29 00:00:00 | 10022.210625
2014-06-30 00:00:00 | 18631.27875
2014-07-01 00:00:00 | 23515.485
2014-07-02 00:00:00 | 34248.519375
2014-07-03 00:00:00 | 42163.550625
2014-07-04 00:00:00 | 51273.02250000001
2014-07-05 00:00:00 | 28944.050625
2014-07-06 00:00:00 | 12005.870625
2014-07-07 00:00:00 | 13152.969375
2014-07-08 00:00:00 | 21320.761875
2014-07-09 00:00:00 | 28554.27750000001
2014-07-10 00:00:00 | 34935.15375
2014-07-11 00:00:00 | 50818.50375
2014-07-12 00:00:00 | 32767.35
2014-07-13 00:00:00 | 12254.89125
2014-07-14 00:00:00 | 23919.86625
2014-07-15 00:00:00 | 30338.46375
2014-07-16 00:00:00 | 26040.5775
2014-07-17 00:00:00 | 40774.65
2014-07-18 00:00:00 | 57139.674375
2014-07-19 00:00:00 | 32609.1675
2014-07-20 00:00:00 | 13800.5175
2014-07-21 00:00:00 | 21951.43125000001
2014-07-22 00:00:00 | 30770.4075
2014-07-23 00:00:00 | 36044.2425
2014-07-24 00:00:00 | 36148.546875
2014-07-25 00:00:00 | 66588.29625
2014-07-26 00:00:00 | 34750.56375
2014-07-27 00:00:00 | 9783.45375
2014-07-28 00:00:00 | 21671.79
2014-07-29 00:00:00 | 24079.558125
2014-07-30 00:00:00 | 30281.698125
2014-07-31 00:00:00 | 37075.31625
2014-08-01 00:00:00 | 52863.2475
2014-08-02 00:00:00 | 31165.404375
2014-08-03 00:00:00 | 11473.14
2014-08-04 00:00:00 | 15446.76
2014-08-05 00:00:00 | 21384.2475
2014-08-06 00:00:00 | 35599.0425
2014-08-07 00:00:00 | 44756.814375
2014-08-08 00:00:00 | 50087.57250000002
2014-08-09 00:00:00 | 36727.700625
2014-08-10 00:00:00 | 11204.221875
2014-08-11 00:00:00 | 19905.020625
2014-08-12 00:00:00 | 33208.035
2014-08-13 00:00:00 | 39310.543125
2014-08-14 00:00:00 | 34879.4775
2014-08-15 00:00:00 | 56137.46249999999
2014-08-16 00:00:00 | 35206.10625
2014-08-17 00:00:00 | 14259.735
2014-08-18 00:00:00 | 25497.478125
2014-08-19 00:00:00 | 31991.649375
2014-08-20 00:00:00 | 32399.994375
2014-08-21 00:00:00 | 41677.978125
2014-08-22 00:00:00 | 48847.74562500001
2014-08-23 00:00:00 | 36072.579375
2014-08-24 00:00:00 | 9493.785000000002
2014-08-25 00:00:00 | 18465.943125
2014-08-26 00:00:00 | 30511.11
2014-08-27 00:00:00 | 29191.91625
2014-08-28 00:00:00 | 32708.025
2014-08-29 00:00:00 | 55466.236875
2014-08-30 00:00:00 | 30646.599375
2014-08-31 00:00:00 | 11675.225625
2014-09-01 00:00:00 | 16981.951875
2014-09-02 00:00:00 | 18258.121875
2014-09-03 00:00:00 | 32769.673125
2014-09-04 00:00:00 | 35135.415
2014-09-05 00:00:00 | 42112.69125
2014-09-06 00:00:00 | 29900.27250000001
2014-09-07 00:00:00 | 11382.81375
2014-09-08 00:00:00 | 19156.095
2014-09-09 00:00:00 | 24908.33625
2014-09-10 00:00:00 | 26777.270625
2014-09-11 00:00:00 | 36430.524375
2014-09-12 00:00:00 | 39825.804375
2014-09-13 00:00:00 | 30186.24
2014-09-14 00:00:00 | 12532.17
2014-09-15 00:00:00 | 27024.92625
2014-09-16 00:00:00 | 25950.185625
2014-09-17 00:00:00 | 32238.75375
2014-09-18 00:00:00 | 49162.535625
2014-09-19 00:00:00 | 27187.8075
2014-09-20 00:00:00 | 24682.53375
2014-09-21 00:00:00 | 11086.280625
2014-09-22 00:00:00 | 18323.484375
2014-09-23 00:00:00 | 21458.5875
2014-09-24 00:00:00 | 32267.445
2014-09-25 00:00:00 | 38657.99437499999
2014-09-26 00:00:00 | 56229.77062500001
2014-09-27 00:00:00 | 28826.765625
2014-09-28 00:00:00 | 16827.391875
2014-09-29 00:00:00 | 13997.668125
2014-09-30 00:00:00 | 21513.79125
2014-10-01 00:00:00 | 25528.636875
2014-10-02 00:00:00 | 32789.62312500001
2014-10-03 00:00:00 | 36778.546875
2014-10-04 00:00:00 | 24884.44875
2014-10-05 00:00:00 | 8796.309374999999
2014-10-06 00:00:00 | 15674.9775
2014-10-07 00:00:00 | 19413.975
2014-10-08 00:00:00 | 32178.418125
2014-10-09 00:00:00 | 27524.07
2014-10-10 00:00:00 | 48048.11812500001
2014-10-11 00:00:00 | 30111.020625
2014-10-12 00:00:00 | 10129.336875
2014-10-13 00:00:00 | 7500.399375000001
2014-10-14 00:00:00 | 19431.496875
2014-10-15 00:00:00 | 22300.254375
2014-10-16 00:00:00 | 41575.69500000001
2014-10-17 00:00:00 | 38899.69125
2014-10-18 00:00:00 | 30365.34375
2014-10-19 00:00:00 | 10406.31375
2014-10-20 00:00:00 | 28125.365625
2014-10-21 00:00:00 | 24057.7575
2014-10-22 00:00:00 | 32618.630625
2014-10-23 00:00:00 | 34677.825
2014-10-24 00:00:00 | 43838.458125
2014-10-25 00:00:00 | 32740.1025
2014-10-26 00:00:00 | 11781.6825
2014-10-27 00:00:00 | 20317.31625
2014-10-28 00:00:00 | 38675.765625
2014-10-29 00:00:00 | 28406.083125
2014-10-30 00:00:00 | 38657.338125
2014-10-31 00:00:00 | 39872.59499999999
2014-11-01 00:00:00 | 31949.491875
2014-11-02 00:00:00 | 11019.56625
2014-11-03 00:00:00 | 19766.341875
2014-11-04 00:00:00 | 42893.0775
2014-11-05 00:00:00 | 30453.6225
2014-11-06 00:00:00 | 32290.09875
2014-11-07 00:00:00 | 45207.15937500001
2014-11-08 00:00:00 | 29300.1975
2014-11-09 00:00:00 | 11047.8375
2014-11-10 00:00:00 | 23705.311875
2014-11-11 00:00:00 | 26485.935
2014-11-12 00:00:00 | 35082.376875
2014-11-13 00:00:00 | 36876.144375
2014-11-14 00:00:00 | 52857.511875
2014-11-15 00:00:00 | 37577.505
2014-11-16 00:00:00 | 12096.13125
2014-11-17 00:00:00 | 16557.52875
2014-11-18 00:00:00 | 28551.46875
2014-11-19 00:00:00 | 36734.000625
2014-11-20 00:00:00 | 40175.07375
2014-11-21 00:00:00 | 60013.3275
2014-11-22 00:00:00 | 33806.11500000001
2014-11-23 00:00:00 | 17838.541875
2014-11-24 00:00:00 | 23225.698125
2014-11-25 00:00:00 | 35130.09937500001
2014-11-26 00:00:00 | 38538.465
2014-11-27 00:00:00 | 62245.25999999999
2014-11-28 00:00:00 | 79237.423125
2014-11-29 00:00:00 | 38150.88375000001
2014-11-30 00:00:00 | 17366.37
2014-12-01 00:00:00 | 33301.03875
2014-12-02 00:00:00 | 40786.64625000001
2014-12-03 00:00:00 | 48397.76812500001
2014-12-04 00:00:00 | 63675.88499999999
2014-12-05 00:00:00 | 80514.669375
2014-12-06 00:00:00 | 38735.73375000001
2014-12-07 00:00:00 | 13257.549375
2014-12-08 00:00:00 | 36241.9575
2014-12-09 00:00:00 | 45267.691875
2014-12-10 00:00:00 | 63911.045625
2014-12-11 00:00:00 | 68069.68875
2014-12-12 00:00:00 | 85130.390625
2014-12-13 00:00:00 | 30725.38875
2014-12-14 00:00:00 | 16008.234375
2014-12-15 00:00:00 | 46010.934375
2014-12-16 00:00:00 | 51745.86375
2014-12-17 00:00:00 | 62012.60625
2014-12-18 00:00:00 | 53755.64249999999
2014-12-19 00:00:00 | 53380.74
2014-12-20 00:00:00 | 30377.773125
2014-12-21 00:00:00 | 27971.566875
2014-12-22 00:00:00 | 29468.919375
2014-12-23 00:00:00 | 36412.595625
2014-12-24 00:00:00 | 26356.07625
2014-12-25 00:00:00 | 15921.110625
2014-12-26 00:00:00 | 20123.145
2014-12-27 00:00:00 | 20514.55875
2014-12-28 00:00:00 | 10421.25
2014-12-29 00:00:00 | 8396.994375
2014-12-30 00:00:00 | 2793.18375
2014-12-31 00:00:00 | 0