Spreadsheet: 726992d1617641002-how-to-sum-cell-values-for-based-criteria-in-the-complex-table-employ-unprotected-v2
Sheet: Sheet1

 |  | WEEK 07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 08
 |  | 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 |  | A |  | -3 |  |  |  |  |  |  |  | M |  |  |  |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | M |  | 2 | -1 |  |  |  |  |  |  | HO |  |  | -1 |  |  |  |  |  |  | HO |  |  |  |  |  |  |  |  |  | DO |  |  | -2 |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | HO |  |  |  |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | M |  | 2 | -1 |  |  |  |  |  |  | DO |  |  | -1 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | DO |  |  | -2
[NAME] |  | 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 |  |  |  |  |  |  | HO |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | M |  | 0.5 | -0.5
Mate |  | 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] |  | 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
 | SUM(SUMIF(INDIRECT(TEXT(--IFERROR(IF(FREQUENCY(IF(IFERROR(C5:EK8="HO";);ROW(5:8)/1%%+COLUMN(C:EK));SMALL(IF(IFERROR(C4:EK4="total day";);ROW(5:8)/1%%+COLUMN(C:EK));ROW(1:100)));SMALL(IF(IFERROR(C4:EK4="total day";);ROW(5:8)/1%%+COLUMN(C:EK));ROW(1:100))););"R0C0000;;R9999C9999"););">0"))
 | SUM(IF(MOD(COLUMN(C5:BS5);10)=1;C5:[NAME]))
 |  | WEEK 07 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEEK 08
 |  | 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 | 20:00:00 | A |  | -3 |  |  |  |  |  |  |  | M |  |  |  |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | M |  | 2 | -1 |  |  |  |  |  |  | HO |  |  | -1 |  |  |  |  |  |  | HO |  |  |  |  |  |  |  |  |  | DO |  |  | -2 |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | HO |  |  |  |  |  |  |  |  |  | A |  | -3 |  |  |  |  |  |  |  | M |  | 2 | -1 |  |  |  |  |  |  | DO |  |  | -1 |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  |  | DO |  |  | -2
[NAME] | 14: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 |  |  |  |  |  |  | HO |  |  |  |  |  |  |  |  |  | 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