Spreadsheet: 701985d1604029781-sumproduct-to-directly-get-the-total-count-for-each-quarter-and-year-sumproduct_roundup_year
Sheet: Sheet1

 | No | Dates | Quarter |  | Quarter/ Year | 2019 | 2020 |  | Quarter/ Year | 2019 | 2020
 | 1 | 2019-08-08 00:00:00 |  |  | Q1 |  |  |  | Q1
 | 2 | 2019-08-08 00:00:00 |  |  | Q2 |  |  |  | Q2
 | 3 | 2019-08-08 00:00:00 |  |  | Q3 |  |  |  | Q3
 | 4 | 2019-08-08 00:00:00 |  |  | Q4 |  |  |  | Q4
 | 5 | 2019-08-08 00:00:00
 | 6 | 2019-08-08 00:00:00
 | 7 | 2019-08-08 00:00:00
 | 8 | 2019-08-08 00:00:00
 | 9 | 2019-08-08 00:00:00
 | 10 | 2019-08-08 00:00:00
 | 11 | 2019-08-08 00:00:00
 | 12 | 2019-08-08 00:00:00
 | 13 | 2019-08-08 00:00:00
 | 14 | 2019-08-08 00:00:00
 | 15 | 2019-08-08 00:00:00
 | 16 | 2019-08-08 00:00:00
 | 17 | 2019-08-08 00:00:00
 | 18 | 2019-08-08 00:00:00
 | 19 | 2019-08-08 00:00:00
 | 20 | 2019-08-15 00:00:00
 | 21 | 2019-08-15 00:00:00
 | 22 | 2019-08-15 00:00:00
 | 23 | 2019-08-15 00:00:00
 | 24 | 2019-08-15 00:00:00
 | 25 | 2019-08-15 00:00:00
 | 26 | 2019-08-15 00:00:00
 | 27 | 2019-08-15 00:00:00
 | 28 | 2019-08-15 00:00:00
 | 29 | 2019-08-15 00:00:00
 | 30 | 2019-08-15 00:00:00
 | 31 | 2019-08-15 00:00:00
 | 32 | 2019-08-15 00:00:00
 | 33 | 2019-08-15 00:00:00
 | 34 | 2019-08-15 00:00:00
 | 35 | 2019-08-15 00:00:00
 | 36 | 2019-09-30 00:00:00
 | 37 | 2019-10-16 00:00:00
 | 38 | 2019-10-16 00:00:00
 | 39 | 2019-10-16 00:00:00
 | 40 | 2019-10-16 00:00:00
 | 41 | 2019-10-23 00:00:00
 | 42 | 2019-10-23 00:00:00
 | 43 | 2019-10-23 00:00:00
 | 44 | 2019-11-07 00:00:00
 | 45 | 2019-11-07 00:00:00
 | 46 | 2019-11-07 00:00:00
 | 47 | 2019-11-07 00:00:00
 | 48 | 2019-11-07 00:00:00
 | 49 | 2019-12-09 00:00:00
 | 50 | 2019-12-09 00:00:00
 | 51 | 2019-12-23 00:00:00
 | 52 | 2019-12-23 00:00:00
 | 53 | 2019-12-23 00:00:00
 | 54 | 2019-12-24 00:00:00
 | 55 | 2019-12-24 00:00:00
 | 56 | 2019-12-24 00:00:00
 | 57 | 2019-12-24 00:00:00
 | 58 | 2019-12-24 00:00:00
 | 59 | 2019-12-24 00:00:00
 | 60 | 2019-12-24 00:00:00
 | 61 | 2019-12-24 00:00:00
 | 62 | 2019-12-30 00:00:00
 | 63 | 2019-12-30 00:00:00
 | 64 | 2020-01-31 00:00:00
 | 65 | 2020-01-31 00:00:00
 | 66 | 2020-01-31 00:00:00
 | 67 | 2020-01-31 00:00:00
 | 68 | 2020-01-31 00:00:00
 | 69 | 2020-01-31 00:00:00
 | 70 | 2020-01-31 00:00:00
 | 71 | 2020-01-31 00:00:00
 | 72 | 2020-01-31 00:00:00
 | 73 | 2020-01-31 00:00:00
 | 74 | 2020-02-03 00:00:00
 | 75 | 2020-02-03 00:00:00
 | 76 | 2020-02-03 00:00:00
 | 77 | 2020-02-03 00:00:00
 | 78 | 2020-02-03 00:00:00
 | 79 | 2020-02-17 00:00:00
 | 80 | 2020-02-17 00:00:00
 | 81 | 2020-03-02 00:00:00
 | 82 | 2020-03-02 00:00:00
 | 83 | 2020-05-13 00:00:00
 | 84 | 2020-05-13 00:00:00
 | 85 | 2020-05-13 00:00:00
 | 86 | 2020-05-13 00:00:00
 | 87 | 2020-06-16 00:00:00
 | 88 | 2020-07-08 00:00:00
 | 89 | 2020-07-08 00:00:00
 | 90 | 2020-07-10 00:00:00
 | 91 | 2020-07-23 00:00:00
 | 92 | 2020-08-12 00:00:00
 | 93 | 2020-08-12 00:00:00
 | 94 | 2020-08-12 00:00:00
 | 95 | 2020-08-12 00:00:00
 | 96 | 2020-08-12 00:00:00
 | 97 | 2020-08-12 00:00:00
 | 98 | 2020-09-01 00:00:00
 | 99 | 2020-09-01 00:00:00
 | 100 | 2020-10-16 00:00:00
 | 101 | 2020-10-19 00:00:00
 | 102 | 2020-10-27 00:00:00
 | 103 | 2020-10-27 00:00:00
 | 104 | 2020-10-27 00:00:00