Spreadsheet: 864949d1712072036-sumifs-to-add-if-theres-a-date-banking
Sheet: How to do it

 | Account | Entered | Banked
 | Checking
 | Savings
 | Grand Total
Account | Entered | Banked | Amount
Savings | 2024-03-28 00:00:00 | 2024-03-31 00:00:00 | 4.46
Checking | 2024-03-25 00:00:00 |  | 929.14
Checking | 2024-03-25 00:00:00 | 2024-03-28 00:00:00 | 1209.84
Checking | 2024-03-25 00:00:00 | 2024-03-28 00:00:00 | -650
Checking | 2024-03-24 00:00:00 |  | 815
Checking | 2024-03-22 00:00:00 | 2024-03-25 00:00:00 | 461
Checking | 2024-03-02 00:00:00 | 2024-03-05 00:00:00 | -3560
Checking | 2024-02-25 00:00:00 |  | -650
Checking | 2024-02-24 00:00:00 | 2024-02-27 00:00:00 | 815
Checking | 2024-02-23 00:00:00 | 2024-02-26 00:00:00 | 461
Checking | 2024-02-02 00:00:00 | 2024-02-05 00:00:00 | -3560
Checking | 2024-01-26 00:00:00 | 2024-01-29 00:00:00 | 815
Checking | 2024-01-26 00:00:00 | 2024-01-29 00:00:00 | -650
Checking | 2024-01-19 00:00:00 | 2024-01-22 00:00:00 | 461
Checking | 2024-01-02 00:00:00 | 2024-01-05 00:00:00 | -3560
Checking | 2023-12-30 00:00:00 | 2024-01-02 00:00:00 | 5000
Savings | 2023-12-28 00:00:00 | 2023-12-31 00:00:00 | 2.27
Savings | 2023-12-28 00:00:00 | 2023-12-31 00:00:00 | 7.3
Checking | 2023-12-25 00:00:00 | 2023-12-28 00:00:00 | -650
Checking | 2023-12-24 00:00:00 | 2023-12-27 00:00:00 | 815
Checking | 2023-12-19 00:00:00 | 2023-12-22 00:00:00 | 452
Checking | 2023-12-02 00:00:00 | 2023-12-05 00:00:00 | -3560
Checking | 2023-12-01 00:00:00 | 2023-12-04 00:00:00 | 5000
Savings | 2023-12-01 00:00:00 | 2023-12-04 00:00:00 | -5000
Checking | 2023-11-26 00:00:00 | 2023-11-29 00:00:00 | 790
Checking | 2023-11-25 00:00:00 | 2023-11-28 00:00:00 | -650
Checking | 2023-11-17 00:00:00 | 2023-11-20 00:00:00 | 452
Checking | 2023-11-03 00:00:00 | 2023-11-06 00:00:00 | -3560
Checking | 2023-10-27 00:00:00 | 2023-10-30 00:00:00 | 790
Checking | 2023-10-27 00:00:00 | 2023-10-30 00:00:00 | -650
Checking | 2023-10-27 00:00:00 | 2023-10-30 00:00:00 | 3000
Savings | 2023-10-27 00:00:00 | 2023-10-30 00:00:00 | -3000
Checking | 2023-10-20 00:00:00 | 2023-10-23 00:00:00 | 452
Checking | 2023-10-10 00:00:00 | 2023-10-13 00:00:00 | 231.22
Checking | 2023-10-02 00:00:00 | 2023-10-05 00:00:00 | -3295
Savings | 2023-09-27 00:00:00 | 2023-09-30 00:00:00 | 7.64
Checking | 2023-09-25 00:00:00 | 2023-09-28 00:00:00 | 790
Checking | 2023-09-22 00:00:00 | 2023-09-25 00:00:00 | 452
Checking | 2023-09-02 00:00:00 | 2023-09-05 00:00:00 | -3295
Checking | 2023-08-27 00:00:00 | 2023-08-30 00:00:00 | 790
Checking | 2023-08-18 00:00:00 | 2023-08-21 00:00:00 | 452
Checking | 2023-08-15 00:00:00 | 2023-08-18 00:00:00 | 5000
Checking | 2023-08-15 00:00:00 | 2023-08-18 00:00:00 | 500
Checking | 2023-08-04 00:00:00 | 2023-08-07 00:00:00 | -3295
Checking | 2023-07-29 00:00:00 | 2023-08-01 00:00:00 | -650
Checking | 2023-07-25 00:00:00 | 2023-07-28 00:00:00 | 790
Checking | 2023-07-21 00:00:00 | 2023-07-24 00:00:00 | 452
Checking | 2023-07-02 00:00:00 | 2023-07-05 00:00:00 | -3295
Savings | 2023-06-27 00:00:00 | 2023-06-30 00:00:00 | 6.8
Checking | 2023-06-26 00:00:00 | 2023-06-29 00:00:00 | 790
Checking | 2023-06-23 00:00:00 | 2023-06-26 00:00:00 | 452
Savings | 2023-06-03 00:00:00 | 2023-06-06 00:00:00 | 6000
Checking | 2023-06-02 00:00:00 | 2023-06-05 00:00:00 | -3295
Checking | 2023-06-02 00:00:00 | 2023-06-05 00:00:00 | 4000
Savings | 2023-06-02 00:00:00 | 2023-06-05 00:00:00 | -4000
Checking | 2023-05-27 00:00:00 | 2023-05-30 00:00:00 | 790
Checking | 2023-05-19 00:00:00 | 2023-05-22 00:00:00 | 452
Checking | 2023-05-02 00:00:00 | 2023-05-05 00:00:00 | -3295
Checking | 2023-04-24 00:00:00 | 2023-04-27 00:00:00 | 790
Checking | 2023-04-21 00:00:00 | 2023-04-24 00:00:00 | 452
Checking | 2023-04-14 00:00:00 | 2023-04-17 00:00:00 | -200
Checking | 2023-04-02 00:00:00 | 2023-04-05 00:00:00 | -3295
Savings | 2023-03-28 00:00:00 | 2023-03-31 00:00:00 | 3.05
Checking | 2023-03-27 00:00:00 | 2023-03-30 00:00:00 | 790
Savings | 2023-03-27 00:00:00 | 2023-03-30 00:00:00 | 5000
Checking | 2023-03-17 00:00:00 | 2023-03-20 00:00:00 | 451
Checking | 2023-03-03 00:00:00 | 2023-03-06 00:00:00 | -3295
Checking | 2023-02-24 00:00:00 | 2023-02-27 00:00:00 | 790
Checking | 2023-02-20 00:00:00 | 2023-02-23 00:00:00 | 5000
Checking | 2023-02-14 00:00:00 | 2023-02-17 00:00:00 | 451
Checking | 2023-02-03 00:00:00 | 2023-02-06 00:00:00 | -3295
Checking | 2023-01-27 00:00:00 | 2023-01-30 00:00:00 | 3353.28
Checking | 2023-01-20 00:00:00 | 2023-01-23 00:00:00 | 451
Checking | 2023-01-15 00:00:00 | 2023-01-18 00:00:00 | -47.98
Checking | 2023-01-03 00:00:00 | 2023-01-06 00:00:00 | -3295
Checking | 2022-12-25 00:00:00 | 2022-12-28 00:00:00 | 376
Checking | 2022-12-20 00:00:00 | 2022-12-23 00:00:00 | 5000
Checking | 2022-12-20 00:00:00 | 2022-12-23 00:00:00 | 397
Checking | 2022-11-18 00:00:00 | 2022-11-21 00:00:00 | 397
Checking | 2022-11-06 00:00:00 | 2022-11-09 00:00:00 | -108.24
Checking | 2022-10-28 00:00:00 | 2022-10-31 00:00:00 | 1000
Checking | 2022-10-28 00:00:00 | 2022-10-31 00:00:00 | 0
Savings | 2022-10-28 00:00:00 | 2022-10-31 00:00:00 | -1000
Savings | 2022-10-25 00:00:00 | 2022-10-28 00:00:00 | 8000
Checking | 2022-10-21 00:00:00 | 2022-10-24 00:00:00 | 397
Savings | 2022-09-27 00:00:00 | 2022-09-30 00:00:00 | 0.18
Checking | 2022-09-26 00:00:00 | 2022-09-29 00:00:00 | -19.77
Checking | 2022-09-26 00:00:00 | 2022-09-29 00:00:00 | 20
Savings | 2022-06-28 00:00:00 | 2022-07-01 00:00:00 | -20
Savings | 2022-06-28 00:00:00 | 2022-07-01 00:00:00 | 1155.47