Spreadsheet: 784269d1655566622-incomprehensible-issue-with-sumifs-between-2-dates-personal-finance-2022-1-tms
Sheet: transactions (solutions)

weekday | day | amount | reason | account |  |  | TMS | TMS
 | 2022-05-16 00:00:00 | -522.32 | aaa | reserve | ok |  | =SUMIFS(C:C,B:B,">="&DATE(2022,5,16),B:B,"<="&DATE(2022,6,15),E:E,"reserve") | =SUMIFS(C:C,B:B,">="&DATE(2022,5,16),B:B,"<="&DATE(2022,6,15),E:E,"reserve")
 | 2022-05-16 00:00:00 | 261 | aaa | chase checking |  |  |  | -6099.599999999999
 | 2022-05-16 00:00:00 | -70 | aaa | reserve | ok
 | 2022-05-17 00:00:00 | -9.99 | aaa | unlimited |  |  | wk9128 | wk9128
 | 2022-05-17 00:00:00 | -1 | aaa | reserve | ok |  | =SUMIFS(C:C,B:B,">="&--"2022/05/16",B:B,"<="&--"2022/06/15",E:E,"reserve",F:[NAME]") | =SUMIFS(C:C,B:B,">="&--"2022/05/16",B:B,"<="&--"2022/06/15",E:E,"reserve",F:[NAME]")
 | 2022-05-18 00:00:00 | -105.79 | aaa | chase checking |  |  |  | -6099.599999999999
 | 2022-05-19 00:00:00 | -40 | aaa | chase checking
 | 2022-05-20 00:00:00 | 3970.96 | aaa | chase checking |  |  | =SUMIFS(C:C,B:B,">="&--"2022/05/16",B:B,"<="&--"2022/06/15",E:E,"reserve") | =SUMIFS(C:C,B:B,">="&--"2022/05/16",B:B,"<="&--"2022/06/15",E:E,"reserve")
 | 2022-05-20 00:00:00 | -1500 | aaa | chase checking |  |  |  | -6099.599999999999
 | 2022-05-20 00:00:00 | 18.05 | aaa | chase checking
 | 2022-05-20 00:00:00 | 1925 | aaa | chase checking |  |  | =SUMIFS(C:C,B:B,">="&--"2022/05/16",B:B,"<="&--"2022/06/15",E:E,"reserve",F:F,"<>ok") | =SUMIFS(C:C,B:B,">="&--"2022/05/16",B:B,"<="&--"2022/06/15",E:E,"reserve",F:F,"<>ok")
 | 2022-05-20 00:00:00 | 141.58 | aaa | chase checking |  |  |  | 0
 | 2022-05-20 00:00:00 | -156.38 | aaa | unlimited
 | 2022-05-20 00:00:00 | 78.19 | aaa | chase checking
 | 2022-05-20 00:00:00 | -3850 | aaa | chase checking |  |  | TMS (365 FILTER) | TMS (365 FILTER)
 | 2022-05-20 00:00:00 | 3850 | aaa | [NAME] |  |  | =SUM(FILTER(C:C,(B:B>=DATE(2022,5,16))*(B:B<=DATE(2022,6,15))*(E:E="reserve"))) | =SUM(FILTER(C:C,(B:B>=DATE(2022,5,16))*(B:B<=DATE(2022,6,15))*(E:E="reserve")))
 | 2022-05-21 00:00:00 | -114.71 | aaa | freedom |  |  |  | -6099.599999999999
 | 2022-05-21 00:00:00 | -84.95 | aaa | reserve | ok
 | 2022-05-23 00:00:00 | 60 | aaa | chase checking
 | 2022-05-24 00:00:00 | -283.15 | aaa | unlimited |  |  | AliG | AliG
 | 2022-05-24 00:00:00 | -0.99 | aaa | unlimited |  |  | =SUMIFS(C:C,B:B,">=16/05/2022",B:B,"<=15/06/2022",E:E,"reserve") | =SUMIFS(C:C,B:B,">=16/05/2022",B:B,"<=15/06/2022",E:E,"reserve")
 | 2022-05-25 00:00:00 | -3853 | aaa | [NAME] |  |  |  | -6099.599999999999
 | 2022-05-25 00:00:00 | -435.82 | aaa | unlimited
 | 2022-05-26 00:00:00 | -36.1 | aaa | chase checking |  |  | =SUMIFS(C:C,B:B,">=05/16/2022",B:B,"<=06/15/2022",E:E,"reserve") | =SUMIFS(C:C,B:B,">=05/16/2022",B:B,"<=06/15/2022",E:E,"reserve")
 | 2022-05-27 00:00:00 | -100 | aaa | chase checking |  |  |  | 0
 | 2022-05-27 00:00:00 | -108.65 | aaa | chase checking
 | 2022-05-28 00:00:00 | 217.91 | aaa | chase checking
 | 2022-05-30 00:00:00 |  | aaa | chase checking
 | 2022-05-30 00:00:00 |  | aaa | chase checking
 | 2022-05-30 00:00:00 |  | aaa | chase checking
 | 2022-05-31 00:00:00 | -23.14 | aaa | freedom
 | 2022-06-01 00:00:00 | 205.8 | aaa | chase checking
 | 2022-06-01 00:00:00 | -244.37 | aaa | reserve | ok
 | 2022-06-01 00:00:00 | -38 | aaa | reserve | ok
 | 2022-06-01 00:00:00 | -81.61 | aaa | reserve | ok
 | 2022-06-01 00:00:00 | -76 | aaa | reserve | ok
 | 2022-06-01 00:00:00 | -253.34 | aaa | reserve | ok
 | 2022-06-01 00:00:00 | -86.22 | aaa | unlimited
 | 2022-06-01 00:00:00 | -10 | aaa | unlimited
 | 2022-06-01 00:00:00 | -25.91 | aaa
 | 2022-06-01 00:00:00 | -550 | aaa | reserve | ok
 | 2022-06-01 00:00:00 |  | aaa | reserve
 | 2022-06-02 00:00:00 | -20 | aaa | reserve | ok
 | 2022-06-02 00:00:00 | -14.78 | aaa | reserve | ok
 | 2022-06-03 00:00:00 | -2 | aaa | unlimited
 | 2022-06-03 00:00:00 | 3970.96 | aaa | chase checking
 | 2022-06-03 00:00:00 | -1724.09 | aaa | chase checking
 | 2022-06-03 00:00:00 | -108.37 | aaa | chase checking
 | 2022-06-03 00:00:00 | -55 | aaa | chase checking
 | 2022-06-03 00:00:00 | -40 | aaa | chase checking
 | 2022-06-03 00:00:00 | -69.9 | aaa | unlimited
 | 2022-06-03 00:00:00 | -14.64 | aaa | unlimited
 | 2022-06-03 00:00:00 | -35 | aaa | unlimited
 | 2022-06-03 00:00:00 | -253.08 | aaa | reserve | ok
 | 2022-06-03 00:00:00 | -60 | aaa | reserve | ok
 | 2022-06-03 00:00:00 | -31.1 | aaa | reserve | ok
 | 2022-06-03 00:00:00 | -17 | aaa | reserve | ok
 | 2022-06-04 00:00:00 | -54.5 | aaa | reserve | ok
 | 2022-06-04 00:00:00 | -108.78 | aaa | reserve | ok
 | 2022-06-04 00:00:00 | -254.07 | aaa | reserve | ok
 | 2022-06-05 00:00:00 | -76.38 | aaa | reserve | ok
 | 2022-06-05 00:00:00 | -208.57 | aaa | reserve | ok
 | 2022-06-05 00:00:00 | -45.27 | aaa | reserve | ok
 | 2022-06-05 00:00:00 | -9 | aaa | reserve | ok
 | 2022-06-05 00:00:00 | -7.47 | aaa | reserve | ok
 | 2022-06-05 00:00:00 | -23.12 | aaa | reserve | ok
 | 2022-06-05 00:00:00 | -85.6 | aaa | reserve | ok
 | 2022-06-05 00:00:00 | -93.56 | aaa | unlimited
 | 2022-06-06 00:00:00 | -30 | aaa | unlimited
 | 2022-06-06 00:00:00 | -87.27 | aaa | unlimited
 | 2022-06-06 00:00:00 | -161.82 | aaa | unlimited
 | 2022-06-07 00:00:00 | -411.6 | aaa | chase checking
 | 2022-06-08 00:00:00 | 1725 | aaa | chase checking
 | 2022-06-08 00:00:00 | -1884 | aaa | reserve | ok
 | 2022-06-09 00:00:00 | -136.67 | aaa | unlimited
 | 2022-06-10 00:00:00 | -99 | aaa | unlimited
 | 2022-06-10 00:00:00 | -106.45 | aaa | chase checking
 | 2022-06-10 00:00:00 | -16.6 | aaa | reserve | ok
 | 2022-06-13 00:00:00 | -1566 | aaa | reserve | ok
 | 2022-06-13 00:00:00 |  | aaa | chase checking
 | 2022-06-14 00:00:00 | 22.47 | aaa | chase checking
 | 2022-06-14 00:00:00 | 85.4 | aaa | chase checking
 | 2022-06-15 00:00:00 | 252.89 | aaa | reserve | ok
 | 2022-06-15 00:00:00 | 283.18 | aaa | reserve | ok
 | 2022-06-16 00:00:00 | -327.19 | aaa | reserve | [NAME]
 | 2022-06-15 00:00:00 | 21.24 | aaa | reserve | ok
 | 2022-06-17 00:00:00 | -18.58 | aaa | reserve | [NAME]
 | 2022-06-17 00:00:00 | -9.99 | aaa | unlimited
 | 2022-06-17 00:00:00 | 3970.96 | aaa | chase checking
 | 2022-06-17 00:00:00 | -1250 | aaa | chase checking
 | 2022-06-24 00:00:00 | -288.97 | aaa | unlimited
 | 2022-06-20 00:00:00 | 144.48 | aaa | chase checking
 | 2022-06-24 00:00:00 | -0.99 | aaa | unlimited
 | 2022-06-25 00:00:00 | 1925 | aaa | chase checking
 | 2022-06-25 00:00:00 | -3850 | aaa | chase checking
 | 2022-06-25 00:00:00 | 3850 | aaa | [NAME]
 | 2022-06-25 00:00:00 | -3853 | aaa | [NAME]
 | 2022-06-26 00:00:00 | -44.94 | aaa | chase checking
 | 2022-06-30 00:00:00 | 60 | aaa | chase checking
 | 2022-07-01 00:00:00 | 3970.96 | aaa | chase checking
 | 2022-07-01 00:00:00 |  | aaa | chase checking
 | 2022-07-01 00:00:00 | 205.8 | aaa | chase checking
 | 2022-07-01 00:00:00 | -170.8 | aaa | unlimited
 | 2022-07-07 00:00:00 | -411.6 | aaa | chase checking
 | 2022-07-07 00:00:00 | -39.95 | aaa | unlimited
 | 2022-07-09 00:00:00 | -136.67 | aaa | unlimited
 | 2022-07-10 00:00:00 | -99 | aaa | unlimited
 | 2022-07-12 00:00:00 |  | aaa | chase checking |  |  | true sum | true sum
 | 2022-07-12 00:00:00 |  | aaa | chase checking
 | 2022-07-14 00:00:00 |  | aaa | chase checking
 | 2022-07-15 00:00:00 | 3970.96 | aaa | chase checking
 | 2022-07-15 00:00:00 | -1250 | aaa | chase checking
 | 2022-07-17 00:00:00 | -9.99 | aaa | unlimited
 | 2022-07-20 00:00:00 |  | aaa | chase checking
 | 2022-07-24 00:00:00 | -288.97 | aaa | unlimited
 | 2022-07-20 00:00:00 | 144.48 | aaa | chase checking
 | 2022-07-24 00:00:00 | -0.99 | aaa | unlimited
 | 2022-07-25 00:00:00 | 1925 | aaa | chase checking
 | 2022-07-25 00:00:00 | -3850 | aaa | chase checking
 | 2022-07-25 00:00:00 | 3850 | aaa | [NAME]
 | 2022-07-25 00:00:00 | -3853 | aaa | [NAME]
 | 2022-07-29 00:00:00 | 3970.96 | aaa | chase checking
 | 2022-07-29 00:00:00 | -1250 | aaa | chase checking
 | 2022-07-30 00:00:00 | 60 | aaa | chase checking
 | 2022-08-01 00:00:00 | 205.8 | aaa | chase checking
 | 2022-08-07 00:00:00 | -411.6 | aaa | chase checking
 | 2022-08-09 00:00:00 | -136.67 | aaa | unlimited
 | 2022-08-10 00:00:00 | -99 | aaa | unlimited
 | 2022-08-12 00:00:00 | 3970.95 | aaa | chase checking
 | 2022-08-12 00:00:00 | -1500 | aaa | chase checking
 | 2022-08-12 00:00:00 |  | aaa | chase checking