Spreadsheet: 726070d1617032480-how-to-sum-cell-values-for-based-criteria-in-the-complex-table-employ
Sheet: Sheet1

 |  | WEEK 07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 07
 |  | 2021-02-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-17 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-18 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-25 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-26 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-27 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-02-28 00:00:00
employer | HO hours | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | total week | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | oo | shift | start time | correct. | correct. | note | end time | SUW | BHW | total day | total week
Ana | 13:00:00 | A |  | -3 |  |  |  |  |  |  |  | M |  |  |  |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | M |  | 2 | -1 |  |  |  |  |  |  | HO |  |  | -1 |  |  |  |  |  |  | HO |  |  |  |  |  |  |  |  |  | DO |  |  | -2 |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | M |  |  |  |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | M |  | 2 | -1 |  |  |  |  |  |  | DO |  |  | -1 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | DO |  |  | -2
[NAME] | 07:00:00 | DO |  |  |  |  |  |  |  |  |  | A |  | 1 | -1 |  |  |  |  |  |  | M |  | 0.5 | -1.5 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | HO |  |  |  |  |  |  |  |  |  | M |  | 0.5 | -0.5 |  |  |  |  |  |  | DO |  |  |  |  |  |  |  |  |  | A |  | 1 | -1 |  |  |  |  |  |  | M |  | 0.5 | -1.5 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | M |  | 0.5 | -0.5
Mate | 00:00:00 | M |  | 0.5 | 0.5 |  |  |  |  |  |  | M |  | -1 |  |  |  |  |  |  |  | A |  | 0.5 | -0.5 |  |  |  |  |  |  | M |  | -1 |  |  |  |  |  |  |  | M |  | -0.5 | -0.5 |  |  |  |  |  |  | DO |  |  |  |  |  |  |  |  |  | A |  | 1 | -1 |  |  |  |  |  |  | M |  | 0.5 | 0.5 |  |  |  |  |  |  | M |  | -1 |  |  |  |  |  |  |  | A |  | 0.5 | -0.5 |  |  |  |  |  |  | M |  | -1 |  |  |  |  |  |  |  | M |  | -0.5 | -0.5 |  |  |  |  |  |  | DO |  |  |  |  |  |  |  |  |  | A |  | 1 | -1
[NAME] | 00:00:00 | A |  | 1.5 | -1.5 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  | 1.5 | -1.5 |  |  |  |  |  |  | DO |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  | 1.5 | -1.5 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  | 1.5 | -1.5 |  |  |  |  |  |  | DO |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A