Spreadsheet: 743223d1628308501-formula-for-sum-if-date-and-criteria-match-excel-upload
Sheet: Sheet1

Date | Person | Debit |  |  |  | Guy 1 | Guy 2 | Guy 3 | total
2020-01-15 00:00:00 | Guy 1 | 747.5 |  | 2019 | Count:
2020-01-22 00:00:00 | Guy 1 | 851.25 |  |  | Debit:
2020-01-25 00:00:00 | Guy 1 | 1083 |  | 2020 | Count:
2020-01-11 00:00:00 | Guy 2 | 830.5 |  |  | Debit:
2020-01-15 00:00:00 | Guy 2 | 371 |  | 2021 | Count:
2020-01-25 00:00:00 | Guy 2 | 1278 |  |  | Debit:
2020-01-06 00:00:00 | Guy 4 | 1190
2020-01-03 00:00:00 | Guy 4 | 803
2020-02-10 00:00:00 | Guy 1 | 1643
2020-02-10 00:00:00 | Guy 2 | 634
2020-02-18 00:00:00 | Guy 2 | 589
2020-02-24 00:00:00 | Guy 1 | 1023.5
2020-03-03 00:00:00 | Guy 2 | 288
2020-02-24 00:00:00 | Guy 4 | 340.5
2020-03-05 00:00:00 | Guy 1 | 1002
2020-03-09 00:00:00 | Guy 2 | 860
2020-03-16 00:00:00 | Guy 2 | 866
2020-03-16 00:00:00 | Guy 1 | 2224.75
2020-03-20 00:00:00 | Guy 2 | 648
2020-03-30 00:00:00 | Guy 1 | 1428
2020-03-30 00:00:00 | Guy 2 | 382.5
2020-05-27 00:00:00 | Guy 1 | 721
2020-06-09 00:00:00 | Guy 1 | 1180
2020-08-03 00:00:00 | Guy 2 | 626
2020-08-10 00:00:00 | Guy 1 | 713
2020-08-10 00:00:00 | Guy 2 | 1345
2020-08-24 00:00:00 | Guy 1 | 684
2020-08-24 00:00:00 | Guy 2 | 207
2020-08-31 00:00:00 | Guy 2 | 773
2020-08-31 00:00:00 | Guy 1 | 995
2020-09-08 00:00:00 | Guy 1 | 1617.5
2020-02-03 00:00:00 | Guy 2 | 755
2020-09-08 00:00:00 | Guy 2 | 421
2020-02-03 00:00:00 | Guy 1 | 925
2020-09-11 00:00:00 | Guy 2 | 358
2020-09-14 00:00:00 | Guy 1 | 1650
2020-09-21 00:00:00 | Guy 2 | 1304.5
2020-09-23 00:00:00 | Guy 1 | 953.5
2020-06-15 00:00:00 | Guy 2 | 317
2020-09-28 00:00:00 | Guy 2 | 727.5
2020-06-15 00:00:00 | Guy 1 | 843
2020-06-22 00:00:00 | Guy 2 | 380
2020-09-29 00:00:00 | Guy 1 | 1090
2020-06-30 00:00:00 | Guy 1 | 850
2020-10-05 00:00:00 | Guy 2 | 663
2020-07-06 00:00:00 | Guy 2 | 962
2020-10-06 00:00:00 | Guy 1 | 821
2020-10-13 00:00:00 | Guy 2 | 642.5
2020-07-10 00:00:00 | Guy 1 | 1522
2020-10-19 00:00:00 | Guy 2 | 558
2020-10-20 00:00:00 | Guy 3 | 317
2020-07-13 00:00:00 | Guy 2 | 949.5
2020-10-26 00:00:00 | Guy 2 | 431
2020-07-20 00:00:00 | Guy 1 | 1053
2020-10-27 00:00:00 | Guy 3 | 295
2020-07-20 00:00:00 | Guy 2 | 724
2020-10-27 00:00:00 | Guy 1 | 523
2020-07-27 00:00:00 | Guy 2 | 325
2020-08-03 00:00:00 | Guy 1 | 1191
2020-11-02 00:00:00 | Guy 2 | 285
2020-11-02 00:00:00 | Guy 1 | 1388
2020-11-10 00:00:00 | Guy 3 | 244
2020-11-09 00:00:00 | Guy 1 | 1217
2020-11-09 00:00:00 | Guy 2 | 772
2020-11-16 00:00:00 | Guy 2 | 571
2020-11-17 00:00:00 | Guy 1 | 1627.5
2020-11-23 00:00:00 | Guy 1 | 1461
2020-11-23 00:00:00 | Guy 2 | 810
2020-12-04 00:00:00 | Guy 3 | 139
2020-12-01 00:00:00 | Guy 1 | 322
2020-12-07 00:00:00 | Guy 1 | 1337
2020-12-07 00:00:00 | Guy 3 | 244
2020-12-07 00:00:00 | Guy 2 | 1332.5
2020-12-14 00:00:00 | Guy 2 | 522
2020-12-15 00:00:00 | Guy 3 | 474
2020-12-15 00:00:00 | Guy 1 | 1807
2020-12-21 00:00:00 | Guy 2 | 718
2020-12-22 00:00:00 | Guy 3 | 96
2020-12-22 00:00:00 | Guy 1 | 132
2020-12-29 00:00:00 | Guy 3 | 292
2021-06-22 00:00:00 | Guy 1 | 747.5
2021-09-29 00:00:00 | Guy 1 | 851.25
2021-06-30 00:00:00 | Guy 1 | 1083
2021-10-05 00:00:00 | Guy 2 | 830.5
2021-07-06 00:00:00 | Guy 2 | 371
2021-10-06 00:00:00 | Guy 2 | 1278
2021-10-13 00:00:00 | Guy 4 | 1190
2021-07-10 00:00:00 | Guy 4 | 803
2021-10-19 00:00:00 | Guy 1 | 1643
2021-10-20 00:00:00 | Guy 2 | 634
2021-07-13 00:00:00 | Guy 2 | 589
2021-10-26 00:00:00 | Guy 1 | 1023.5
2021-07-20 00:00:00 | Guy 2 | 288
2021-10-27 00:00:00 | Guy 4 | 340.5
2021-07-20 00:00:00 | Guy 1 | 1002
2021-10-27 00:00:00 | Guy 2 | 860
2021-07-27 00:00:00 | Guy 2 | 866
2021-08-03 00:00:00 | Guy 1 | 2224.75
2021-11-02 00:00:00 | Guy 2 | 648
2021-11-02 00:00:00 | Guy 1 | 1428
2021-11-10 00:00:00 | Guy 2 | 382.5
2021-11-09 00:00:00 | Guy 1 | 721
2021-11-09 00:00:00 | Guy 1 | 1180
2021-11-16 00:00:00 | Guy 2 | 626
2021-11-17 00:00:00 | Guy 1 | 713
2021-11-23 00:00:00 | Guy 2 | 1345
2021-11-23 00:00:00 | Guy 1 | 684
2021-12-04 00:00:00 | Guy 2 | 207
2021-12-01 00:00:00 | Guy 2 | 773
2021-12-07 00:00:00 | Guy 1 | 995
2021-12-07 00:00:00 | Guy 1 | 1617.5
2021-12-07 00:00:00 | Guy 2 | 755
2021-12-14 00:00:00 | Guy 2 | 421
2021-12-15 00:00:00 | Guy 1 | 925
2021-12-15 00:00:00 | Guy 2 | 358
2021-12-21 00:00:00 | Guy 1 | 1650
2021-12-22 00:00:00 | Guy 2 | 1304.5
2021-12-22 00:00:00 | Guy 1 | 953.5
2021-12-29 00:00:00 | Guy 2 | 317
2019-09-29 00:00:00 | Guy 2 | 727.5
2019-06-30 00:00:00 | Guy 1 | 843
2019-10-05 00:00:00 | Guy 2 | 380
2019-07-06 00:00:00 | Guy 1 | 1090
2019-10-06 00:00:00 | Guy 1 | 850
2019-10-13 00:00:00 | Guy 2 | 663
2019-07-10 00:00:00 | Guy 2 | 962
2019-10-19 00:00:00 | Guy 1 | 821
2019-10-20 00:00:00 | Guy 2 | 642.5
2019-07-13 00:00:00 | Guy 1 | 1522
2019-10-26 00:00:00 | Guy 2 | 558
2019-07-20 00:00:00 | Guy 3 | 317
2019-10-27 00:00:00 | Guy 2 | 949.5
2019-07-20 00:00:00 | Guy 2 | 431
2019-10-27 00:00:00 | Guy 1 | 1053
2019-07-27 00:00:00 | Guy 3 | 295
2019-08-03 00:00:00 | Guy 2 | 724
2019-11-02 00:00:00 | Guy 1 | 523
2019-11-02 00:00:00 | Guy 2 | 325
2019-11-10 00:00:00 | Guy 1 | 1191
2019-11-09 00:00:00 | Guy 2 | 285
2019-11-09 00:00:00 | Guy 1 | 1388
2019-11-16 00:00:00 | Guy 3 | 244
2019-11-17 00:00:00 | Guy 1 | 1217
2019-11-23 00:00:00 | Guy 2 | 772
2019-11-23 00:00:00 | Guy 2 | 571
2019-12-04 00:00:00 | Guy 1 | 1627.5
2019-12-01 00:00:00 | Guy 1 | 1461
2019-12-07 00:00:00 | Guy 2 | 810
2019-12-07 00:00:00 | Guy 3 | 139
2019-12-07 00:00:00 | Guy 1 | 322
2019-12-14 00:00:00 | Guy 1 | 1337
2019-12-15 00:00:00 | Guy 3 | 244
2019-12-15 00:00:00 | Guy 2 | 1332.5
2019-12-21 00:00:00 | Guy 2 | 522
2019-12-22 00:00:00 | Guy 3 | 474
2019-12-22 00:00:00 | Guy 1 | 1807
2019-12-29 00:00:00 | Guy 2 | 718
2019-09-29 00:00:00 | Guy 3 | 96
2019-06-30 00:00:00 | Guy 1 | 132
2019-10-05 00:00:00 | Guy 3 | 292