Spreadsheet: 784142d1655470038-help-with-two-sum-calculations-with-specific-criteria-sample-salary-calculations
Sheet: Sheet1

Date | Bi-weekly Salary | Monthly Salary |  | Sum previous 36 months | Average of last 36
 |  | [NAME] to achieve this: sum(where like 1/*/19 etc) then drag formula down? |  | formula to sum last 36 months that ignores spaces?
2019-01-13 00:00:00 | 100 |  |  | N/A
2019-01-27 00:00:00 | 100 | 200 |  | N/A
2019-02-10 00:00:00 | 100 |  |  | N/A
2019-02-24 00:00:00 | 100 | 200 |  | N/A
2019-03-10 00:00:00 | 100 |  |  | N/A
2019-03-24 00:00:00 | 100 | 200 |  | N/A
2019-04-07 00:00:00 | 100 |  |  | N/A
2019-04-21 00:00:00 | 100 | 200 |  | N/A
2019-05-05 00:00:00 | 100 |  |  | N/A
2019-05-19 00:00:00 | 100 | 200 |  | N/A
2019-06-02 00:00:00 | 100 |  |  | N/A
2019-06-16 00:00:00 | 100 |  |  | N/A
2019-06-30 00:00:00 | 100 | 300 |  | N/A
2019-07-14 00:00:00 | 100 |  |  | N/A
2019-07-28 00:00:00 | 100 | 200 |  | N/A
2019-08-11 00:00:00 | 100 |  |  | N/A
2019-08-25 00:00:00 | 100 | 200 |  | N/A
2019-09-08 00:00:00 | 100 |  |  | N/A
2019-09-22 00:00:00 | 100 | 200 |  | N/A
2019-10-06 00:00:00 | 100 |  |  | N/A
2019-10-20 00:00:00 | 100 | 200 |  | N/A
2019-11-03 00:00:00 | 100 |  |  | N/A
2019-11-17 00:00:00 | 100 | 200 |  | N/A
2019-12-01 00:00:00 | 100 |  |  | N/A
2019-12-15 00:00:00 | 100 |  |  | N/A
2019-12-29 00:00:00 | 100 | 300 |  | N/A
2020-01-12 00:00:00 | 100 |  |  | N/A
2020-01-26 00:00:00 | 100 | 200 |  | N/A
2020-02-09 00:00:00 | 100 |  |  | N/A
2020-02-23 00:00:00 | 100 | 200 |  | N/A
2020-03-08 00:00:00 | 100 |  |  | N/A
2020-03-22 00:00:00 | 100 | 200 |  | N/A
2020-04-05 00:00:00 | 100 |  |  | N/A
2020-04-19 00:00:00 | 100 | 200 |  | N/A
2020-05-03 00:00:00 | 100 |  |  | N/A
2020-05-17 00:00:00 | 100 |  |  | N/A
2020-05-31 00:00:00 | 100 | 300 |  | N/A
2020-06-14 00:00:00 | 100 |  |  | N/A
2020-06-28 00:00:00 | 100 | 200 |  | N/A
2020-07-12 00:00:00 | 100 |  |  | N/A
2020-07-26 00:00:00 | 100 | 200 |  | N/A
2020-08-09 00:00:00 | 100 |  |  | N/A
2020-08-23 00:00:00 | 100 | 200 |  | N/A
2020-09-06 00:00:00 | 100 |  |  | N/A
2020-09-20 00:00:00 | 100 | 200 |  | N/A
2020-10-04 00:00:00 | 100 |  |  | N/A
2020-10-18 00:00:00 | 100 | 200 |  | N/A
2020-11-01 00:00:00 | 100 |  |  | N/A
2020-11-15 00:00:00 | 100 |  |  | N/A
2020-11-29 00:00:00 | 100 | 300 |  | N/A
2020-12-13 00:00:00 | 100 |  |  | N/A
2020-12-27 00:00:00 | 100 | 300 |  | N/A
2021-01-10 00:00:00 | 100 |  |  | N/A
2021-01-24 00:00:00 | 100 | 200 |  | N/A
2021-02-07 00:00:00 | 100 |  |  | N/A
2021-02-21 00:00:00 | 100 | 200 |  | N/A
2021-03-07 00:00:00 | 100 |  |  | N/A
2021-03-21 00:00:00 | 100 | 200 |  | N/A
2021-04-04 00:00:00 | 100 |  |  | N/A
2021-04-18 00:00:00 | 100 | 200 |  | N/A
2021-05-02 00:00:00 | 100 |  |  | N/A
2021-05-16 00:00:00 | 100 |  |  | N/A
2021-05-30 00:00:00 | 100 | 300 |  | N/A
2021-06-13 00:00:00 | 100 |  |  | N/A
2021-06-27 00:00:00 | 100 | 200 |  | N/A
2021-07-11 00:00:00 | 100 |  |  | N/A
2021-07-25 00:00:00 | 100 | 200 |  | N/A
2021-08-08 00:00:00 | 100 |  |  | N/A
2021-08-22 00:00:00 | 100 | 200 |  | N/A
2021-09-05 00:00:00 | 100 |  |  | N/A
2021-09-19 00:00:00 | 100 | 200 |  | N/A
2021-10-03 00:00:00 | 100 |  |  | N/A
2021-10-17 00:00:00 | 100 | 200 |  | N/A
2021-10-31 00:00:00 | 100 |  |  | N/A
2021-11-14 00:00:00 | 100 |  |  | N/A
2021-11-28 00:00:00 | 100 | 300 |  | N/A
2021-12-12 00:00:00 | 100 |  |  | N/A
2021-12-26 00:00:00 | 100 | 200 |  | N/A
2022-01-09 00:00:00 | 100 |  |  | 7900
2022-01-23 00:00:00 | 100 | 200
2022-02-06 00:00:00 | 100
2022-02-20 00:00:00 | 100 | 200
2022-03-06 00:00:00 | 100
2022-03-20 00:00:00 | 100 | 200
2022-04-03 00:00:00 | 100
2022-04-17 00:00:00 | 100 | 200
2022-05-01 00:00:00 | 100
2022-05-15 00:00:00 | 100
2022-05-29 00:00:00 | 100 | 300
2022-06-12 00:00:00 | 100
2022-06-26 00:00:00 | 100 | 200