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

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
12:00:00 | 20:45:00 | 1 |  |  | 1 | 1 | 1 | 1 | 2012-08-15 00:00:00 |  |  | 05:55:00 | 14:45:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-08-15 00:00:00 |  |  | 08:00:00 | 17:00:00 | 1 | 1 |  |  | 1 | 1 | 1 | 2012-08-16 00:00:00
14:30:00 | 23:15:00 | 1 | 1 | 1 |  |  | 1 | 1 | 2012-08-13 00:00:00 |  |  | 09:45:00 | 18:45:00 | 1 | 1 | 1 | 1 | 1 |  |  | 2012-07-13 00:00:00 |  |  | 05:30:00 | 14:15:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 2012-08-19 00:00:00
06:45:00 | 15:30:00 |  | 1 | 1 | 1 |  | 1 | 1 | 2012-08-17 00:00:00 |  |  | 11:15:00 | 22:15:00 |  | 1 | 1 |  | 1 | 1 | 1 | 2012-09-02 00:00:00 |  |  | leave |  |  |  |  |  |  |  |  | 2012-08-29 00:00:00
11:45:00 | 20:15:00 | 1 | 1 | 1 | 1 |  |  |  | 2012-08-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | leave |  |  |  |  |  |  |  |  | 2012-08-29 00:00:00
07:45:00 | 16:30:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-08-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00 | 02:00:00 | 1 | 1 | 1 | 1 | 1 |  |  | 2012-08-30 00:00:00
11:00:00 | 20:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-08-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:45:00 | 20:30:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-09-02 00:00:00
11:00:00 | 22:00:00 |  | 1 |  |  | 1 | 1 | 1 | 2012-08-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 23:00:00 | 1 | 1 | 1 | 1 |  |  |  | 2012-09-05 00:00:00
09:15:00 | 20:15:00 |  | 1 |  |  | 1 | 1 | 1 | 2012-08-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:45:00 | 20:30:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-09-12 00:00:00
08:30:00 | 17:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-08-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00 | 02:00:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-09-12 00:00:00
14:15:00 | 23:00:00 | 1 | 1 | 1 | 1 |  | 1 |  | 2012-08-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:15:00 | 02:00:00 | 1 | 1 | 1 | 1 | 1 |  |  | 2012-09-27 00:00:00
06:45:00 | 15:30:00 |  | 1 | 1 | 1 |  | 1 | 1 | 2012-08-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:30:00 | 21:00:00 | 1 | 1 | 1 |  |  | 1 | 1 | 2012-09-25 00:00:00
leave |  |  |  |  |  |  |  |  | 2012-08-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:30:00 | 11:15:00 | 1 | 1 |  | 1 | 1 | 1 |  | 2012-10-31 00:00:00
11:45:00 | 22:45:00 | 1 | 1 | 1 |  | 1 |  |  | 2012-08-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:15:00 | 20:00:00 | 1 | 1 | 1 |  |  |  |  | 2012-11-05 00:00:00
16:00:00 | 20:00:00 | 1 | 1 |  | 1 | 1 |  |  | 2012-09-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:00:00 | 01:00:00 | 1 | 1 |  |  | 1 | 1 |  | 2012-11-01 00:00:00
11:30:00 | 20:00:00 |  | 1 |  |  |  | 1 | 1 | 2012-09-01 00:00:00
12:15:00 | 23:15:00 | 1 | 1 | 1 | 1 | 1 |  |  | 2012-09-06 00:00:00
11:00:00 | 20:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-10 00:00:00
11:00:00 | 20:00:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-09-12 00:00:00
11:00:00 | 19:30:00 |  |  | 1 | 1 | 1 | 1 | 1 | 2012-09-11 00:00:00
09:00:00 | 20:00:00 | 1 | 1 |  | 1 |  |  | 1 | 2012-09-12 00:00:00
08:00:00 | 12:00:00 | 1 | 1 | 1 | 1 | 1 | 1 |  | 2012-09-04 00:00:00
leave |  |  |  |  |  |  |  |  | 2012-09-01 00:00:00
11:00:00 | 20:00:00 | 1 | 1 | 1 | 1 |  |  | 1 | 2012-09-24 00:00:00
12:15:00 | 23:15:00 |  | 1 | 1 | 1 |  | 1 |  | 2012-10-02 00:00:00
09:30:00 | 20:30:00 |  | 1 |  | 1 | 1 | 1 |  | 2012-10-11 00:00:00
11:00:00 | 20:00:00 | 1 | 1 | 1 | 1 |  |  | 1 | 2012-10-12 00:00:00
15:00:00 | 00:00:00 | 1 | 1 | 1 |  |  | 1 | 1 | 2012-10-13 00:00:00
10:45:00 | 19:15:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-10-14 00:00:00
10:45:00 | 19:15:00 |  | 1 | 1 | 1 | 1 | 1 | 1 | 2012-10-14 00:00:00
07:00:00 | 15:30:00 |  | 1 |  | 1 | 1 | 1 | 1 | 2012-10-14 00:00:00
07:30:00 | 16:30:00 | 1 | 1 | 1 | 1 | 1 |  |  | 2012-10-17 00:00:00
leave |  |  |  |  |  |  |  |  | 2012-10-31 00:00:00
07:30:00 | 16:30:00 | 1 | 1 | 1 | 1 | 1 |  |  | 2012-10-31 00:00:00
11:00:00 | 22:00:00 |  | 1 | 1 |  | 1 | 1 |  | 2012-11-01 00:00:00
leave |  |  |  |  |  |  |  |  | 2012-10-27 00:00:00
09:15:00 | 20:15:00 |  | 1 |  |  | 1 | 1 | 1 | 2012-11-02 00:00:00
leave |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00
11:00:00 | 22:00:00 |  | 1 | 1 |  | 1 | 1 |  | 2012-10-22 00:00:00
12:30:00 | 09:15:00 |  | 1 | 1 | 1 | 1 | 1 |  | 2012-11-08 00:00:00