Spreadsheet: 701391d1603735178-sumif-formula-problems-test-sumif
Sheet: Sheet1

 | Dates |  |  |  |  |  |  | Fees | Test
 | 2021-08-04 00:00:00 |  |  |  |  |  |  | 83
 | 2021-06-25 00:00:00 |  |  |  |  |  |  | 103
 | 2021-07-16 00:00:00 |  |  |  |  |  |  | 55
 | 2020-07-12 00:00:00 |  |  |  |  |  |  | 115
 | 2021-03-23 00:00:00 |  |  |  |  |  |  | 48
 | 2021-06-24 00:00:00 |  |  |  |  |  |  | 106
 | 2021-02-03 00:00:00 |  |  |  |  |  |  | 14
 | 2021-08-26 00:00:00 |  |  |  |  |  |  | 104
 | 2021-01-27 00:00:00 |  |  |  |  |  |  | 62
 | 2020-09-02 00:00:00 |  |  |  |  |  |  | 66
 | 2020-09-19 00:00:00 |  |  |  |  |  |  | 124
 | 2020-11-13 00:00:00 |  |  |  |  |  |  | 12
 | 2021-01-27 00:00:00 |  |  |  |  |  |  | 87
 | 2020-11-21 00:00:00 |  |  |  |  |  |  | 23
 | 2020-08-04 00:00:00 |  |  |  |  |  |  | 36
 | 2021-10-30 00:00:00 |  |  |  |  |  |  | 102
 | 2021-03-15 00:00:00 |  |  |  |  |  |  | 21
 | 2020-09-20 00:00:00 |  |  |  |  |  |  | 18
 | 2021-10-09 00:00:00 |  |  |  |  |  |  | 15
 | 2020-09-16 00:00:00 |  |  |  |  |  |  | 9
 | 2021-07-06 00:00:00 |  |  |  |  |  |  | 35
 | 2021-04-11 00:00:00 |  |  |  |  |  |  | 115
 | 2021-02-09 00:00:00 |  |  |  |  |  |  | 125
 | 2021-05-02 00:00:00 |  |  |  |  |  |  | 125
 | 2020-06-28 00:00:00 |  |  |  |  |  |  | 61
 | 2021-02-27 00:00:00 |  |  |  |  |  |  | 85
 | 2021-08-16 00:00:00 |  |  |  |  |  |  | 118
 | 2021-10-07 00:00:00 |  |  |  |  |  |  | 10
 | 2021-06-29 00:00:00 |  |  |  |  |  |  | 64
 | 2020-08-24 00:00:00 |  |  |  |  |  |  | 106
 | 2021-04-23 00:00:00 |  |  |  |  |  |  | 28
 | 2021-06-04 00:00:00 |  |  |  |  |  |  | 92
 | 2021-06-13 00:00:00 |  |  |  |  |  |  | 8
 | 2020-08-22 00:00:00 |  |  |  |  |  |  | 65
 | 2021-09-24 00:00:00 |  |  |  |  |  |  | 106
 | 2021-02-17 00:00:00 |  |  |  |  |  |  | 86
 | 2020-08-05 00:00:00 |  |  |  |  |  |  | 52
 | 2021-04-03 00:00:00 |  |  |  |  |  |  | 69
 | 2021-09-12 00:00:00 |  |  |  |  |  |  | 71
 | 2021-08-16 00:00:00 |  |  |  |  |  |  | 117
 | 2020-08-17 00:00:00 |  |  |  |  |  |  | 122
 | 2021-06-06 00:00:00 |  |  |  |  |  |  | 16
 | 2021-03-23 00:00:00 |  |  |  |  |  |  | 90
 | 2020-07-22 00:00:00 |  |  |  |  |  |  | 22
 | 2021-09-03 00:00:00 |  |  |  |  |  |  | 100
 | 2021-08-09 00:00:00 |  |  |  |  |  |  | 90
 | 2020-08-13 00:00:00 |  |  |  |  |  |  | 58
 | 2021-03-20 00:00:00 |  |  |  |  |  |  | 104
 | 2021-04-18 00:00:00 |  |  |  |  |  |  | 49
 | 2021-10-30 00:00:00 |  |  |  |  |  |  | 33
 | 2021-03-21 00:00:00 |  |  |  |  |  |  | 58
 | 2020-10-13 00:00:00 |  |  |  |  |  |  | 20
 | 2021-09-30 00:00:00 |  |  |  |  |  |  | 111
 | 2021-06-04 00:00:00 |  |  |  |  |  |  | 5
 | 2021-03-06 00:00:00 |  |  |  |  |  |  | 41
 | 2020-06-29 00:00:00 |  |  |  |  |  |  | 48
 | 2020-08-07 00:00:00 |  |  |  |  |  |  | 51
 | 2021-10-10 00:00:00 |  |  |  |  |  |  | 23
 | 2021-09-27 00:00:00 |  |  |  |  |  |  | 104
 | 2021-06-02 00:00:00 |  |  |  |  |  |  | 30
 | 2020-12-30 00:00:00 |  |  |  |  |  |  | 47
 | 2020-11-18 00:00:00 |  |  |  |  |  |  | 122
 | 2021-03-29 00:00:00 |  |  |  |  |  |  | 102
 | 2021-08-25 00:00:00 |  |  |  |  |  |  | 58
 | 2020-11-10 00:00:00 |  |  |  |  |  |  | 125
 | 2020-12-30 00:00:00 |  |  |  |  |  |  | 90
 | 2020-09-05 00:00:00 |  |  |  |  |  |  | 81
 | 2020-07-25 00:00:00 |  |  |  |  |  |  | 63
 | 2021-02-19 00:00:00 |  |  |  |  |  |  | 2
 | 2021-04-18 00:00:00 |  |  |  |  |  |  | 2
 | 2020-07-20 00:00:00 |  |  |  |  |  |  | 101
 | 2020-07-19 00:00:00 |  |  |  |  |  |  | 34
 | 2020-08-02 00:00:00 |  |  |  |  |  |  | 60
 | 2021-02-08 00:00:00 |  |  |  |  |  |  | 36
 | 2021-07-10 00:00:00 |  |  |  |  |  |  | 68
 | 2021-04-11 00:00:00 |  |  |  |  |  |  | 15
 | 2020-07-31 00:00:00 |  |  |  |  |  |  | 55
 | 2020-06-21 00:00:00 |  |  |  |  |  |  | 117
 | 2020-10-09 00:00:00 |  |  |  |  |  |  | 75
 | 2020-07-05 00:00:00 |  |  |  |  |  |  | 108
 | 2020-11-29 00:00:00 |  |  |  |  |  |  | 80
 | 2020-10-23 00:00:00 |  |  |  |  |  |  | 120
 | 2021-03-16 00:00:00 |  |  |  |  |  |  | 31
 | 2021-09-10 00:00:00 |  |  |  |  |  |  | 84
 | 2021-06-30 00:00:00 |  |  |  |  |  |  | 14
 | 2021-10-23 00:00:00 |  |  |  |  |  |  | 25
 | 2021-03-02 00:00:00 |  |  |  |  |  |  | 9
 | 2021-06-22 00:00:00 |  |  |  |  |  |  | 67
 | 2020-11-04 00:00:00 |  |  |  |  |  |  | 72
 | 2020-08-21 00:00:00 |  |  |  |  |  |  | 88
 | 2021-01-25 00:00:00 |  |  |  |  |  |  | 102
 | 2021-10-17 00:00:00 |  |  |  |  |  |  | 64
 | 2021-05-27 00:00:00 |  |  |  |  |  |  | 84
 | 2021-03-11 00:00:00 |  |  |  |  |  |  | 37
 | 2021-02-20 00:00:00 |  |  |  |  |  |  | 53
 | 2021-07-21 00:00:00 |  |  |  |  |  |  | 51
 | 2020-11-19 00:00:00 |  |  |  |  |  |  | 57
 | 2021-04-27 00:00:00 |  |  |  |  |  |  | 10
 | 2021-07-30 00:00:00 |  |  |  |  |  |  | 69
 | 2021-03-18 00:00:00 |  |  |  |  |  |  | 9
 | 2021-05-30 00:00:00 |  |  |  |  |  |  | 26
 | 2020-12-21 00:00:00 |  |  |  |  |  |  | 19
 | 2021-02-25 00:00:00 |  |  |  |  |  |  | 66
 | 2021-03-23 00:00:00 |  |  |  |  |  |  | 79
 | 2021-03-27 00:00:00 |  |  |  |  |  |  | 77
 | 2021-08-18 00:00:00 |  |  |  |  |  |  | 107
 | 2020-10-11 00:00:00 |  |  |  |  |  |  | 51
 | 2020-11-22 00:00:00 |  |  |  |  |  |  | 30
 | 2020-11-04 00:00:00 |  |  |  |  |  |  | 25
 | 2021-10-02 00:00:00 |  |  |  |  |  |  | 74
 | 2020-12-05 00:00:00 |  |  |  |  |  |  | 88
 | 2021-07-18 00:00:00 |  |  |  |  |  |  | 103
 | 2021-10-14 00:00:00 |  |  |  |  |  |  | 13
 | 2021-04-24 00:00:00 |  |  |  |  |  |  | 75
 | 2020-12-02 00:00:00 |  |  |  |  |  |  | 73