Spreadsheet: 743196d1628282350-formula-for-sum-if-date-and-criteria-match-excel-upload
Sheet: Sheet1

Date | Person |  | Totals | 2019 | 2020 | 2021
2020-01-15 00:00:00 | Guy 1 |  | Guy 1
2020-01-22 00:00:00 | Guy 1 |  | Guy 2
2020-01-25 00:00:00 | Guy 1 |  | Guy 3
2020-01-11 00:00:00 | Guy 2
2020-01-15 00:00:00 | Guy 2
2020-01-25 00:00:00 | Guy 2
2020-01-06 00:00:00 | Guy 4
2020-01-03 00:00:00 | Guy 4
2020-02-10 00:00:00 | Guy 1
2020-02-10 00:00:00 | Guy 2
2020-02-18 00:00:00 | Guy 2
2020-02-24 00:00:00 | Guy 1
2020-03-03 00:00:00 | Guy 2
2020-02-24 00:00:00 | Guy 4
2020-03-05 00:00:00 | Guy 1
2020-03-09 00:00:00 | Guy 2
2020-03-16 00:00:00 | Guy 2
2020-03-16 00:00:00 | Guy 1
2020-03-20 00:00:00 | Guy 2
2020-03-30 00:00:00 | Guy 1
2020-03-30 00:00:00 | Guy 2
2020-05-27 00:00:00 | Guy 1
2020-06-09 00:00:00 | Guy 1
2020-08-03 00:00:00 | Guy 2
2020-08-10 00:00:00 | Guy 1
2020-08-10 00:00:00 | Guy 2
2020-08-24 00:00:00 | Guy 1
2020-08-24 00:00:00 | Guy 2
2020-08-31 00:00:00 | Guy 2
2020-08-31 00:00:00 | Guy 1
2020-09-08 00:00:00 | Guy 1
2020-02-03 00:00:00 | Guy 2
2020-09-08 00:00:00 | Guy 2
2020-02-03 00:00:00 | Guy 1
2020-09-11 00:00:00 | Guy 2
2020-09-14 00:00:00 | Guy 1
2020-09-21 00:00:00 | Guy 2
2020-09-23 00:00:00 | Guy 1
2020-06-15 00:00:00 | Guy 2
2020-09-28 00:00:00 | Guy 2
2020-06-15 00:00:00 | Guy 1
2020-06-22 00:00:00 | Guy 2
2020-09-29 00:00:00 | Guy 1
2020-06-30 00:00:00 | Guy 1
2020-10-05 00:00:00 | Guy 2
2020-07-06 00:00:00 | Guy 2
2020-10-06 00:00:00 | Guy 1
2020-10-13 00:00:00 | Guy 2
2020-07-10 00:00:00 | Guy 1
2020-10-19 00:00:00 | Guy 2
2020-10-20 00:00:00 | Guy 3
2020-07-13 00:00:00 | Guy 2
2020-10-26 00:00:00 | Guy 2
2020-07-20 00:00:00 | Guy 1
2020-10-27 00:00:00 | Guy 3
2020-07-20 00:00:00 | Guy 2
2020-10-27 00:00:00 | Guy 1
2020-07-27 00:00:00 | Guy 2
2020-08-03 00:00:00 | Guy 1
2020-11-02 00:00:00 | Guy 2
2020-11-02 00:00:00 | Guy 1
2020-11-10 00:00:00 | Guy 3
2020-11-09 00:00:00 | Guy 1
2020-11-09 00:00:00 | Guy 2
2020-11-16 00:00:00 | Guy 2
2020-11-17 00:00:00 | Guy 1
2020-11-23 00:00:00 | Guy 1
2020-11-23 00:00:00 | Guy 2
2020-12-04 00:00:00 | Guy 3
2020-12-01 00:00:00 | Guy 1
2020-12-07 00:00:00 | Guy 1
2020-12-07 00:00:00 | Guy 3
2020-12-07 00:00:00 | Guy 2
2020-12-14 00:00:00 | Guy 2
2020-12-15 00:00:00 | Guy 3
2020-12-15 00:00:00 | Guy 1
2020-12-21 00:00:00 | Guy 2
2020-12-22 00:00:00 | Guy 3
2020-12-22 00:00:00 | Guy 1
2020-12-29 00:00:00 | Guy 3
2021-06-22 00:00:00 | Guy 1
2021-09-29 00:00:00 | Guy 1
2021-06-30 00:00:00 | Guy 1
2021-10-05 00:00:00 | Guy 2
2021-07-06 00:00:00 | Guy 2
2021-10-06 00:00:00 | Guy 2
2021-10-13 00:00:00 | Guy 4
2021-07-10 00:00:00 | Guy 4
2021-10-19 00:00:00 | Guy 1
2021-10-20 00:00:00 | Guy 2
2021-07-13 00:00:00 | Guy 2
2021-10-26 00:00:00 | Guy 1
2021-07-20 00:00:00 | Guy 2
2021-10-27 00:00:00 | Guy 4
2021-07-20 00:00:00 | Guy 1
2021-10-27 00:00:00 | Guy 2
2021-07-27 00:00:00 | Guy 2
2021-08-03 00:00:00 | Guy 1
2021-11-02 00:00:00 | Guy 2
2021-11-02 00:00:00 | Guy 1
2021-11-10 00:00:00 | Guy 2
2021-11-09 00:00:00 | Guy 1
2021-11-09 00:00:00 | Guy 1
2021-11-16 00:00:00 | Guy 2
2021-11-17 00:00:00 | Guy 1
2021-11-23 00:00:00 | Guy 2
2021-11-23 00:00:00 | Guy 1
2021-12-04 00:00:00 | Guy 2
2021-12-01 00:00:00 | Guy 2
2021-12-07 00:00:00 | Guy 1
2021-12-07 00:00:00 | Guy 1
2021-12-07 00:00:00 | Guy 2
2021-12-14 00:00:00 | Guy 2
2021-12-15 00:00:00 | Guy 1
2021-12-15 00:00:00 | Guy 2
2021-12-21 00:00:00 | Guy 1
2021-12-22 00:00:00 | Guy 2
2021-12-22 00:00:00 | Guy 1
2021-12-29 00:00:00 | Guy 2
2019-09-29 00:00:00 | Guy 2
2019-06-30 00:00:00 | Guy 1
2019-10-05 00:00:00 | Guy 2
2019-07-06 00:00:00 | Guy 1
2019-10-06 00:00:00 | Guy 1
2019-10-13 00:00:00 | Guy 2
2019-07-10 00:00:00 | Guy 2
2019-10-19 00:00:00 | Guy 1
2019-10-20 00:00:00 | Guy 2
2019-07-13 00:00:00 | Guy 1
2019-10-26 00:00:00 | Guy 2
2019-07-20 00:00:00 | Guy 3
2019-10-27 00:00:00 | Guy 2
2019-07-20 00:00:00 | Guy 2
2019-10-27 00:00:00 | Guy 1
2019-07-27 00:00:00 | Guy 3
2019-08-03 00:00:00 | Guy 2
2019-11-02 00:00:00 | Guy 1
2019-11-02 00:00:00 | Guy 2
2019-11-10 00:00:00 | Guy 1
2019-11-09 00:00:00 | Guy 2
2019-11-09 00:00:00 | Guy 1
2019-11-16 00:00:00 | Guy 3
2019-11-17 00:00:00 | Guy 1
2019-11-23 00:00:00 | Guy 2
2019-11-23 00:00:00 | Guy 2
2019-12-04 00:00:00 | Guy 1
2019-12-01 00:00:00 | Guy 1
2019-12-07 00:00:00 | Guy 2
2019-12-07 00:00:00 | Guy 3
2019-12-07 00:00:00 | Guy 1
2019-12-14 00:00:00 | Guy 1
2019-12-15 00:00:00 | Guy 3
2019-12-15 00:00:00 | Guy 2
2019-12-21 00:00:00 | Guy 2
2019-12-22 00:00:00 | Guy 3
2019-12-22 00:00:00 | Guy 1
2019-12-29 00:00:00 | Guy 2
2019-09-29 00:00:00 | Guy 3
2019-06-30 00:00:00 | Guy 1
2019-10-05 00:00:00 | Guy 3