Spreadsheet: 220802d1363269725-sumproduct-to-extract-quarterly-data-started-but-not-working-usepivottable
Sheet: Sheet1

 | 2012-10-31 00:00:00 | 0 |  | Row Labels | Sum of  - |  | Sum of  - | Column Labels
 | 2012-11-01 00:00:00 | 0 |  | 2012 | 0 |  | Row Labels | Qtr1 | Qtr2 | Qtr3 | Qtr4 | Year Total
 | 2012-12-01 00:00:00 | 0 |  | 2013 | 10774430.47536535 |  | 2012 |  |  |  | 0 | 0
 | 2013-01-01 00:00:00 | 0 |  | 2014 | 32530526.52732104 |  | 2013 | 0 | 1728144 | 3517213.372416 | 5529073.102949352 | 10774430.47536535
 | 2013-02-01 00:00:00 | 0 |  | 2015 | 52082421.05721162 |  | 2014 | 6758192.886876021 | 7602047.883502908 | 8551269.990428617 | 9619015.766513498 | 32530526.52732104
 | 2013-03-01 00:00:00 | 0 |  | 2016 | 83385634.13360366 |  | 2015 | 10820084.55118344 | 12171123.58858241 | 13690858.76434717 | 15400354.15309861 | 52082421.05721162
 | 2013-04-01 00:00:00 | 390000 |  | 2017 | 133503086.8135964 |  | 2016 | 17323303.97407112 | 19486361.00148953 | 21919505.98157953 | 24656463.17646348 | 83385634.13360366
 | 2013-05-01 00:00:00 | 573600 |  | Grand Total | 312276099.0070981 |  | 2017 | 27735167.79452942 | 31198291.78602554 | 35093835.29159583 | 39475791.94144566 | 133503086.8135964
 | 2013-06-01 00:00:00 | 764544
 | 2013-07-01 00:00:00 | 963125.76
 | 2013-08-01 00:00:00 | 1169650.7904
 | 2013-09-01 00:00:00 | 1384436.822016
 | 2013-10-01 00:00:00 | 1607814.29489664
 | 2013-11-01 00:00:00 | 1840126.866692506
 | 2013-12-01 00:00:00 | 2081131.941360206
 | 2014-01-01 00:00:00 | 2164977.219014614
 | 2014-02-01 00:00:00 | 2251576.307775199
 | 2014-03-01 00:00:00 | 2341639.360086207
 | 2014-04-01 00:00:00 | 2435304.934489655
 | 2014-05-01 00:00:00 | 2532717.131869242
 | 2014-06-01 00:00:00 | 2634025.817144011
 | 2014-07-01 00:00:00 | 2739386.849829772
 | 2014-08-01 00:00:00 | 2848962.323822964
 | 2014-09-01 00:00:00 | 2962920.816775882
 | 2014-10-01 00:00:00 | 3081437.649446917
 | 2014-11-01 00:00:00 | 3204695.155424794
 | 2014-12-01 00:00:00 | 3332882.961641786
 | 2015-01-01 00:00:00 | 3466198.280107458
 | 2015-02-01 00:00:00 | 3604846.211311756
 | 2015-03-01 00:00:00 | 3749040.059764226
 | 2015-04-01 00:00:00 | 3899001.662154795
 | 2015-05-01 00:00:00 | 4054961.728640987
 | 2015-06-01 00:00:00 | 4217160.197786626
 | 2015-07-01 00:00:00 | 4385846.605698092
 | 2015-08-01 00:00:00 | 4561280.469926016
 | 2015-09-01 00:00:00 | 4743731.688723057
 | 2015-10-01 00:00:00 | 4933480.956271979
 | 2015-11-01 00:00:00 | 5130820.194522859
 | 2015-12-01 00:00:00 | 5336053.002303773
 | 2016-01-01 00:00:00 | 5549495.122395924
 | 2016-02-01 00:00:00 | 5771474.92729176
 | 2016-03-01 00:00:00 | 6002333.924383431
 | 2016-04-01 00:00:00 | 6242427.281358768
 | 2016-05-01 00:00:00 | 6492124.372613119
 | 2016-06-01 00:00:00 | 6751809.347517645
 | 2016-07-01 00:00:00 | 7021881.721418351
 | 2016-08-01 00:00:00 | 7302756.990275086
 | 2016-09-01 00:00:00 | 7594867.269886089
 | 2016-10-01 00:00:00 | 7898661.960681533
 | 2016-11-01 00:00:00 | 8214608.439108795
 | 2016-12-01 00:00:00 | 8543192.776673147
 | 2017-01-01 00:00:00 | 8884920.487740073
 | 2017-02-01 00:00:00 | 9240317.307249676
 | 2017-03-01 00:00:00 | 9609929.999539664
 | 2017-04-01 00:00:00 | 9994327.19952125
 | 2017-05-01 00:00:00 | 10394100.2875021
 | 2017-06-01 00:00:00 | 10809864.29900219
 | 2017-07-01 00:00:00 | 11242258.87096227
 | 2017-08-01 00:00:00 | 11691949.22580076
 | 2017-09-01 00:00:00 | 12159627.1948328
 | 2017-10-01 00:00:00 | 12646012.28262611
 | 2017-11-01 00:00:00 | 13151852.77393115
 | 2017-12-01 00:00:00 | 13677926.8848884