Spreadsheet: 686668d1594743606-sumifs-by-month-and-year-2020-07-14-oeldere-whoisdane-686663d1594740528-sumifs-by-month-and-year-sumifs-by-month-and-y
Sheet: Sheet1

EST Close Date | AMOUNT | year | month
 | 65162.5 |  |  |  |  | 2017 | 2018 | 2019 | 2020
 | 100000 |  |  |  | January
 | 100000 |  |  |  | February
 | 105000 |  |  |  | March
2020-08-30 00:00:00 | 135000 |  |  |  | April
2020-07-17 00:00:00 | 174740 |  |  |  | May
2017-10-16 00:00:00 | 180000 |  |  |  | June
 | 185000 |  |  |  | July
 | 191000 |  |  |  | August
 | 197395 |  |  |  | September
 | 203080 |  |  |  | October
2018-07-26 00:00:00 | 205000 |  |  |  | November
2019-01-17 00:00:00 | 210680 |  |  |  | December
2020-06-08 00:00:00 | 225000
 | 226100
2018-12-18 00:00:00 | 230000
2019-07-22 00:00:00 | 233750
2017-10-17 00:00:00 | 238000
2018-04-09 00:00:00 | 240000 |  |  |  | Som van AMOUNT | Kolomlabels
2018-10-23 00:00:00 | 240000 |  |  |  | Rijlabels | 2017 | 2018 | 2019 | 2020 | Eindtotaal
 | 240014 |  |  |  | 1 |  | 616985 | 210680 |  | 827665
2018-01-26 00:00:00 | 251250 |  |  |  | 3 |  |  | 974000 | 312085 | 1286085
2019-09-23 00:00:00 | 252000 |  |  |  | 4 |  | 240000 | 273000 | 3338810.1 | 3851810.1
 | 252000 |  |  |  | 5 |  |  | 416100 | 305500 | 721600
 | 254750 |  |  |  | 6 |  | 412153 |  | 888260.5 | 1300413.5
2019-10-31 00:00:00 | 255000 |  |  |  | 7 |  | 928750 | 233750 | 3450240 | 4612740
2019-11-06 00:00:00 | 255000 |  |  |  | 8 |  |  | 1478517 | 2353382.5 | 3831899.5
2020-07-17 00:00:00 | 260000 |  |  |  | 9 |  | 630220 | 252000 |  | 882220
 | 260000 |  |  |  | 10 | 729250 | 849765 | 255000 |  | 1834015
 | 260000 |  |  |  | 11 |  |  | 670850 |  | 670850
 | 260000 |  |  |  | 12 | 360000 | 644950 |  |  | 1004950
 | 260000 |  |  |  | Eindtotaal | 1089250 | 4322823 | 4763897 | 10648278.1 | 20824248.1
 | 264127.7375
2020-06-01 00:00:00 | 266260.5
2019-08-31 00:00:00 | 272000
2019-04-29 00:00:00 | 273000
 | 273095
 | 275000
2020-07-01 00:00:00 | 277000
 | 279537.5
 | 281801.14
 | 284000
 | 284620
2019-03-22 00:00:00 | 290000
 | 290014
2020-07-17 00:00:00 | 291000
 | 291442.86
 | 291442.86
 | 291442.86
 | 294750
 | 295000
 | 295000
2018-09-10 00:00:00 | 297220
2018-10-30 00:00:00 | 300000
 | 302974.1
 | 304486.875
2020-05-08 00:00:00 | 305500
2019-03-06 00:00:00 | 306000
2018-10-16 00:00:00 | 309765
2017-10-31 00:00:00 | 311250
2020-03-09 00:00:00 | 312085
2018-07-05 00:00:00 | 313625
 | 329000
2020-07-24 00:00:00 | 332000
2018-09-10 00:00:00 | 333000
 | 338000
 | 338318.75
 | 340000
2020-04-21 00:00:00 | 340826
 | 341100
2020-07-06 00:00:00 | 343500
 | 345404
 | 345950
 | 346442.86
 | 349365.62
 | 350000
 | 352939.2075
 | 354642.82
 | 356000
 | 356000
 | 356650
2017-12-26 00:00:00 | 360000
2019-08-26 00:00:00 | 361517
 | 361617.66
 | 362000
 | 363000
 | 364750
 | 364943.04165
2018-01-29 00:00:00 | 365735
 | 367580
 | 368207.8125
 | 368207.8125
 | 370452
2019-03-21 00:00:00 | 378000
2020-07-14 00:00:00 | 380000
 | 380000
 | 383025.76
 | 386270
 | 390000
 | 393000
2020-06-23 00:00:00 | 397000
 | 400000
 | 400000
 | 407000
 | 407000
 | 408405
 | 408405
2018-07-26 00:00:00 | 410125
2020-07-17 00:00:00 | 412000
2018-06-08 00:00:00 | 412153
2018-12-31 00:00:00 | 414950
2019-11-06 00:00:00 | 415850
2019-05-07 00:00:00 | 416100
2020-08-16 00:00:00 | 417000
 | 417000
 | 417000
2019-08-12 00:00:00 | 420000
2019-08-30 00:00:00 | 425000
2020-08-10 00:00:00 | 426000
 | 434551.14
2020-04-27 00:00:00 | 435870
2020-07-17 00:00:00 | 440000
 | 483312.5
 | 495000
 | 495000
2020-04-30 00:00:00 | 501549.34
 | 521000
 | 531000
 | 532174
 | 536000
 | 536000
 | 536000
 | 536000
 | 536000
2020-07-31 00:00:00 | 540000
 | 551900
 | 558352
 | 560000
 | 580000
 | 592250
 | 592250
 | 606550
 | 609900
 | 609900
 | 613679.6875
 | 638226.875
 | 645192
2020-04-23 00:00:00 | 650000
 | 654864.76
2020-04-24 00:00:00 | 667814.76
2020-08-30 00:00:00 | 680000
2020-08-15 00:00:00 | 695382.5
 | 695868.75
2020-04-30 00:00:00 | 742750