Spreadsheet: 194989d1353386504-how-to-count-cell-values-based-on-2-conditions-example_excel_help
Sheet: Rancho

Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated |  |  | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated |  |  | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Date Shift Vacated
730a | 430p | 1 | 1 | 1 | 1 |  |  | 1 | 2012-08-19 00:00:00 |  |  | 12p | 845p |  |  | 1 | 1 | 1 | 1 | 1 | 2012-08-22 00:00:00 |  |  | 555a | 240p | 1 | 1 | 1 | 1 | 1 |  |  | 2012-09-07 00:00:00
1230p | 915p | 1 | 1 | 1 | 1 | 1 |  |  | 2012-08-17 00:00:00 |  |  | 455a | 155p | 1 | 1 | 1 |  |  | 1 | 1 | 2012-09-02 00:00:00 |  |  | 8a | 5p |  | 1 | 1 | 1 |  | 1 | 1 | 2012-09-25 00:00:00
215p | 11p | 1 | 1 | 1 | 1 |  |  | 1 | 2012-08-21 00:00:00 |  |  | 455a | 155p | 1 | 1 | 1 |  |  | 1 | 1 | 2012-09-02 00:00:00 |  |  | 10a | 645p |  | 1 | 1 |  | 1 | 1 | 1 | 2012-10-04 00:00:00
11a | 745p | 1 | 1 | 1 | 1 | 1 |  |  | 2012-08-21 00:00:00 |  |  | 9a | 545p |  | 1 | 1 | 1 |  | 1 | 1 | 2012-10-07 00:00:00 |  |  | 215p | 11p | 1 | 1 | 1 | 1 | 1 |  |  | 2012-10-08 00:00:00
1045a | 730p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7a | 345p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-15 00:00:00
8a | 445p |  | 1 | 1 | 1 | 1 |  | 1 | 2012-08-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1245p | 930p | 1 | 1 | 1 |  |  | 1 | 1 | 2012-10-21 00:00:00
1130a | 830p | 1 | 1 | 1 | 1 |  |  | 1 | 2012-08-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9a | 8p |  | 1 |  |  | 1 | 1 | 1 | 2012-10-27 00:00:00
1130a | 830p | 1 | 1 | 1 | 1 |  |  | 1 | 2012-08-24 00:00:00
730a | 415p | 1 | 1 | 1 | 1 |  |  | 1 | 2012-08-29 00:00:00
230p | 1115p |  |  | 1 | 1 | 1 | 1 | 1 | 2012-08-30 00:00:00
630a | 315p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-04 00:00:00
10a | 645p | 1 | 1 | 1 | 1 |  |  | 1 | 2012-09-02 00:00:00
2p | 11p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-06 00:00:00
1045a | 730p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-10 00:00:00
215p | 11p | 1 | 1 | 1 | 1 | 1 |  |  | 2012-09-11 00:00:00
1230p | 930p | 1 | 1 | 1 |  |  | 1 | 1 | 2012-09-11 00:00:00
1145a | 845p |  |  | 1 | 1 | 1 | 1 | 1 | 2012-09-12 00:00:00
930a | 230p | 1 | 1 |  |  | 1 | 1 | 1 | 2012-09-14 00:00:00
10a | 645p |  | 1 |  | 1 | 1 | 1 | 1 | 2012-09-19 00:00:00
1230p | 915p | 1 | 1 | 1 | 1 | 1 |  |  | 2012-09-20 00:00:00
8a | 445p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-22 00:00:00
8a | 445p |  | 1 | 1 | 1 | 1 |  | 1 | 2012-09-24 00:00:00
10a | 645p |  | 1 |  | 1 | 1 | 1 | 1 | 2012-09-25 00:00:00
2p | 11p |  |  | 1 | 1 | 1 | 1 | 1 | 2012-09-28 00:00:00
12p | 9p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-29 00:00:00
1230p | 915p | 1 | 1 | 1 | 1 | 1 |  |  | 2012-10-03 00:00:00
1230p | 930p | 1 | 1 | 1 |  |  | 1 | 1 | 2012-10-06 00:00:00
230p | 1115p |  |  | 1 | 1 | 1 | 1 | 1 | 2012-10-10 00:00:00
230p | 1115p | 1 | 1 |  |  | 1 | 1 | 1 | 2012-10-20 00:00:00
230p | 1115p |  |  | 1 | 1 | 1 | 1 | 1 | 2012-10-20 00:00:00
12p | 9p |  |  | 1 | 1 | 1 | 1 | 1 | 2012-10-21 00:00:00
11a | 8p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-25 00:00:00
11a | 8p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-27 00:00:00
9a | 545p |  | 1 | 1 | 1 | 1 | 1 |  | 2012-11-14 00:00:00