Spreadsheet: 96613d1295977216-if-statement-and-countif-statement-in-an-array-schedule-for-excel-forum
Sheet: Shift Schedule

 | Shift Schedule |  |  |  |  |  |  |  |  |  | For the Week of: | 2004-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Department Name:
 | Monday
 |  |  | 7:00:00 A.M. | 8:00:00 A.M. | 9:00:00 A.M. | 10:00:00 A.M. | 11:00:00 A.M. | 12:00:00 P.M. | 1:00:00 P.M. | 2:00:00 P.M. | 3:00:00 P.M. | Sick? | TOTAL
 | [NAME] |  | manager | manager | manager | manager | manager | manager | manager | manager | manager |  | 9
 | [NAME] |  |  | cashier | cashier | cashier | cashier |  |  |  |  |  | 4
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | Sean P |  |  |  |  |  |  |  |  |  |  | Sick | 0
 | Teresa A |  |  |  |  |  |  | cashier | cashier | cashier | cashier |  | 4
 | Tuesday
 |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | Sick? | TOTAL
 | [NAME] |  | manager | manager | manager | manager | manager | manager | manager | manager | manager |  | 9
 | [NAME] |  |  | cashier | cashier | cashier | cashier |  |  |  |  |  | 4
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | Sean P |  |  |  |  |  |  |  |  |  |  | Sick | 0
 | Teresa A |  |  |  |  |  |  | cashier | cashier | cashier | cashier |  | 4
 | Wednesday
 |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | Sick? | TOTAL
 | [NAME] |  | manager | manager | manager | manager | manager | manager | manager | manager | manager |  | 9
 | [NAME] |  |  | cashier | cashier | cashier | cashier |  |  |  |  |  | 4
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | Sean P |  |  |  |  |  |  |  |  |  |  | Sick | 0
 | Teresa A |  |  |  |  |  |  | cashier | cashier | cashier | cashier |  | 4
 | Thursday
 |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | Sick? | TOTAL
 | [NAME] |  | manager | manager | manager | manager | manager | manager | manager | manager | manager |  | 9
 | [NAME] |  |  | cashier | cashier | cashier | cashier |  |  |  |  |  | 4
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | Sean P |  |  |  |  |  |  |  |  |  |  | Sick | 0
 | Teresa A |  |  |  |  |  |  | cashier | cashier | cashier | cashier |  | 4
 | Friday
 |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | Sick? | TOTAL
 | [NAME] |  | manager | manager | manager | manager | manager | manager | manager | manager | manager |  | 9
 | [NAME] |  |  | cashier | cashier | cashier | cashier |  |  |  |  |  | 4
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | Sean P |  |  |  |  |  |  |  |  |  |  | Sick | 0
 | Teresa A |  |  |  |  |  |  | cashier | cashier | cashier | cashier |  | 4
 | Saturday
 |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | Sick? | TOTAL
 | [NAME] |  | manager | manager | manager | manager | manager | manager | manager | manager | manager |  | 9
 | [NAME] |  |  | cashier | cashier | cashier | cashier |  |  |  |  |  | 4
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | Sean P |  |  |  |  |  |  |  |  |  |  | Sick | 0
 | Teresa A |  |  |  |  |  |  | cashier | cashier | cashier | cashier |  | 4
 | Sunday
 |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | Sick? | TOTAL
 | [NAME] |  | manager | manager | manager | manager | manager | manager | manager | manager | manager |  | 9
 | [NAME] |  |  | cashier | cashier | cashier | cashier |  |  |  |  |  | 4
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | Sean P |  |  |  |  |  |  |  |  |  |  | Sick | 0
 | Teresa A |  |  |  |  |  |  | cashier | cashier | cashier | cashier |  | 4
 | Monday
 |  |  | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | Sick? | TOTAL
 | [NAME] |  |  | manager | manager | manager | manager | manager | manager | manager | manager |  | 8
 | [NAME] |  |  | cashier | cashier | cashier | cashier |  |  |  |  |  | 4
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | [NAME] |  |  | front desk | front desk | front desk | front desk | front desk | front desk | front desk |  |  | 7
 | Jill TEST | mgmt | mgmt | mgmt | mgmt | mgmt | mgmt | mgmt | mgmt |  |  |  | 0
 | Sean P |  |  |  |  |  |  |  |  |  |  | Sick | 0
 | Teresa A |  |  |  |  |  |  | cashier | cashier | cashier | cashier |  | 4