Spreadsheet: 195090d1353420042-how-to-count-cell-values-based-on-2-conditions-example_excel_help
Sheet: Department Summary

 | DEPARTMENT
 | Care |  |  |  |  |  |  |  |  |  |  | BL |  |  |  |  |  |  |  |  |  |  | Tech
 | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  |  | Shift Start | Shift End | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | 04:55:00 | 13:25:00 |  |  |  |  |  |  |  |  |  | 04:55:00 | 13:25:00 |  |  |  |  |  |  |  |  |  | 04:55:00 | 13:25:00
 | 05:30:00 | 14:00:00 |  |  |  |  |  |  |  |  |  | 05:30:00 | 14:00:00 |  |  |  |  |  |  |  |  |  | 05:30:00 | 14:00:00
 | 06:45:00 | 15:30:00 |  |  |  |  |  |  |  |  |  | 06:45:00 | 15:30:00 |  |  |  |  |  |  |  |  |  | 06:45:00 | 15:30:00
 | 07:00:00 | 15:30:00 |  |  |  |  |  |  |  |  |  | 07:00:00 | 15:30:00 |  |  |  |  |  |  |  |  |  | 07:00:00 | 15:30:00
 | 07:45:00 | 16:30:00 |  |  |  |  |  |  |  |  |  | 07:45:00 | 16:30:00 |  |  |  |  |  |  |  |  |  | 07:45:00 | 16:30:00
 | 08:00:00 | 12:00:00 |  |  |  |  |  |  |  |  |  | 08:00:00 | 12:00:00 |  |  |  |  |  |  |  |  |  | 08:00:00 | 12:00:00
 | 08:30:00 | 17:00:00 |  |  |  |  |  |  |  |  |  | 08:30:00 | 17:00:00 |  |  |  |  |  |  |  |  |  | 08:30:00 | 17:00:00
 | 09:00:00 | 17:45:00 |  |  |  |  |  |  |  |  |  | 09:00:00 | 17:45:00 |  |  |  |  |  |  |  |  |  | 09:00:00 | 17:45:00
 | 09:00:00 | 20:00:00 |  |  |  |  |  |  |  |  |  | 09:00:00 | 20:00:00 |  |  |  |  |  |  |  |  |  | 09:00:00 | 20:00:00
 | 09:15:00 | 20:15:00 |  |  |  |  |  |  |  |  |  | 09:15:00 | 20:15:00 |  |  |  |  |  |  |  |  |  | 09:15:00 | 20:15:00
 | 09:30:00 | 20:30:00 |  |  |  |  |  |  |  |  |  | 09:30:00 | 20:30:00 |  |  |  |  |  |  |  |  |  | 09:30:00 | 20:30:00
 | 10:00:00 | 21:00:00 |  |  |  |  |  |  |  |  |  | 10:00:00 | 21:00:00 |  |  |  |  |  |  |  |  |  | 10:00:00 | 21:00:00
 | 10:45:00 | 19:15:00 |  |  |  |  |  |  |  |  |  | 10:45:00 | 19:15:00 |  |  |  |  |  |  |  |  |  | 10:45:00 | 19:15:00
 | 11:00:00 | 19:30:00 |  |  |  |  |  |  |  |  |  | 11:00:00 | 19:30:00 |  |  |  |  |  |  |  |  |  | 11:00:00 | 19:30:00
 | 11:00:00 | 20:00:00 |  |  |  |  |  |  |  |  |  | 11:00:00 | 20:00:00 |  |  |  |  |  |  |  |  |  | 11:00:00 | 20:00:00
 | 11:00:00 | 22:00:00 |  |  |  |  |  |  |  |  |  | 11:00:00 | 22:00:00 |  |  |  |  |  |  |  |  |  | 11:00:00 | 22:00:00
 | 11:30:00 | 20:00:00 |  |  |  |  |  |  |  |  |  | 11:30:00 | 20:00:00 |  |  |  |  |  |  |  |  |  | 11:30:00 | 20:00:00
 | 11:30:00 | 20:15:00 |  |  |  |  |  |  |  |  |  | 11:30:00 | 20:15:00 |  |  |  |  |  |  |  |  |  | 11:30:00 | 20:15:00
 | 11:45:00 | 20:15:00 |  |  |  |  |  |  |  |  |  | 11:45:00 | 20:15:00 |  |  |  |  |  |  |  |  |  | 11:45:00 | 20:15:00
 | 11:45:00 | 22:45:00 |  |  |  |  |  |  |  |  |  | 11:45:00 | 22:45:00 |  |  |  |  |  |  |  |  |  | 11:45:00 | 22:45:00
 | 12:00:00 | 20:45:00 |  |  |  |  |  |  |  |  |  | 12:00:00 | 20:45:00 |  |  |  |  |  |  |  |  |  | 12:00:00 | 20:45:00
 | 12:00:00 | 21:00:00 |  |  |  |  |  |  |  |  |  | 12:00:00 | 21:00:00 |  |  |  |  |  |  |  |  |  | 12:00:00 | 21:00:00
 | 12:15:00 | 21:15:00 |  |  |  |  |  |  |  |  |  | 12:15:00 | 21:15:00 |  |  |  |  |  |  |  |  |  | 12:15:00 | 21:15:00
 | 12:15:00 | 23:15:00 |  |  |  |  |  |  |  |  |  | 12:15:00 | 23:15:00 |  |  |  |  |  |  |  |  |  | 12:15:00 | 23:15:00
 | 12:30:00 | 21:00:00 |  |  |  |  |  |  |  |  |  | 12:30:00 | 21:00:00 |  |  |  |  |  |  |  |  |  | 12:30:00 | 21:00:00
 | 14:00:00 | 22:45:00 |  |  |  |  |  |  |  |  |  | 14:00:00 | 22:45:00 |  |  |  |  |  |  |  |  |  | 14:00:00 | 22:45:00
 | 14:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  | 14:00:00 | 23:00:00 |  |  |  |  |  |  |  |  |  | 14:00:00 | 23:00:00
 | 14:15:00 | 23:00:00 |  |  |  |  |  |  |  |  |  | 14:15:00 | 23:00:00 |  |  |  |  |  |  |  |  |  | 14:15:00 | 23:00:00
 | 14:30:00 | 23:15:00 |  |  |  |  |  |  |  |  |  | 14:30:00 | 23:15:00 |  |  |  |  |  |  |  |  |  | 14:30:00 | 23:15:00
 | 14:45:00 | 23:15:00 |  |  |  |  |  |  |  |  |  | 14:45:00 | 23:15:00 |  |  |  |  |  |  |  |  |  | 14:45:00 | 23:15:00
 | 15:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  | 15:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  | 15:00:00 | 00:00:00
 | 16:00:00 | 20:00:00 |  |  |  |  |  |  |  |  |  | 16:00:00 | 20:00:00 |  |  |  |  |  |  |  |  |  | 16:00:00 | 20:00:00