Spreadsheet: 55257d1255417357-match-and-count-unequal-ranges-with-conditions-example-rota
Sheet: Sheet1

 | Department: |  |  | MAIN KITCHEN
 | Shift 1: |  | x | 05.00 - 14.00
 | Shift 2: |  | x | 08.00 - 17.00
 | Shift 3: |  | x | 14.00 - 23.30
 | Shift 4: |  | x | 23.00 - 08.00
 | Shift 5: |  | x | 08.00 - 13.00 + 18.00 - 23.00
 | Shift 6: |  | x | 10.00 - 14.00 + 18.00 - 23.00
 | Day Off |  | o |  | Leave |  | -
 | WEEK |  | 1 |  |  |  |  |  |  | MONDAY |  |  |  |  |  | TUESDAY |  |  |  |  |  | WEDNESDAY |  |  |  |  |  | THURSDAY |  |  |  |  |  | FRIDAY |  |  |  |  |  | SATURDAY |  |  |  |  |  | SUNDAY
 |  |  |  |  |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  |  |  |  | <<SELECT>>
 | Name |  |  |  |  |  | Position |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 |  |  | 1 | MAIN KITCHEN
 |  |  |  |  |  |  | Exec. Chef |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  | o |  |  |  |  |  |  |  | 2 | ADMINISTRATION
 |  |  |  |  |  |  | HOLD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | FRONT OFFICE
 |  |  |  |  |  |  | Pastry Chef |  |  | o |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  |  |  | 4 | STAFF KITCHEN
 |  |  |  |  |  |  | Cook 1 |  |  | x |  |  |  |  |  |  |  | x |  |  |  | o |  |  |  |  |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | 5 | STEWARDING
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  | o |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  | 6 | FOOD & BEVERAGE
 |  |  |  |  |  |  | Cook 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | HOUSEKEEPING
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | ENGINEERING
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | MAINTENANCE
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | ACCOUNTING
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | HUMAN RESOURCES
 | Total Staff On-Duty |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | SPA & FITNESS
 | WEEK |  | 2 |  |  |  |  |  |  | MONDAY |  |  |  |  |  | TUESDAY |  |  |  |  |  | WEDNESDAY |  |  |  |  |  | THURSDAY |  |  |  |  |  | FRIDAY |  |  |  |  |  | SATURDAY |  |  |  |  |  | SUNDAY
 |  |  |  |  |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Name |  |  |  |  |  | Position |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>> | <<SELECT>>
 |  |  |  |  |  |  | Exec. Chef |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  | o |  |  |  |  |  |  |  |  | HOLD | HOLD | HOLD | HOLD | HOLD | HOLD | HOLD | HOLD | HOLD | HOLD | HOLD | HOLD
 |  |  |  |  |  |  | HOLD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exec. Chef | General Manager | Manager
 |  |  |  |  |  |  | Pastry Chef |  |  | x |  |  |  |  |  | o |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  |  |  |  | Sous Chef | Personal Assistant | Assist. Manager
 |  |  |  |  |  |  | Cook 1 |  |  | o |  |  |  |  |  | x |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  |  | Pastry Chef | Senior Secretary | Supervisor 1
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  |  |  |  | o |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | Cook 1 | Secretary | Supervisor 2
 |  |  |  |  |  |  | Cook 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | PABX 1
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cook 3 |  | PABX 2
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cook 4 |  | PABX 3
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cook 5 |  | Reception 1
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bakery 1 |  | Reception 2
 | Total Staff On-Duty |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bakery 2 |  | Reception 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bakery 3 |  | Reception 4
 | WEEK |  | 3 |  |  |  |  |  |  | MONDAY |  |  |  |  |  | TUESDAY |  |  |  |  |  | WEDNESDAY |  |  |  |  |  | THURSDAY |  |  |  |  |  | FRIDAY |  |  |  |  |  | SATURDAY |  |  |  |  |  | SUNDAY |  |  |  |  |  |  |  |  | Pastry 1 |  | Reception 5
 |  |  |  |  |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  |  |  |  | Pastry 2 |  | Guest Activities 1
 | Name |  |  |  |  |  | Position |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  | Pastry 3 |  | Guest Activities 2
 |  |  |  |  |  |  | Exec. Chef |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  | o |  |  |  |  |  |  |  |  | Cold 1 |  | Guest Activities 3
 |  |  |  |  |  |  | HOLD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cold 2 |  | [NAME]
 |  |  |  |  |  |  | Pastry Chef |  |  | x |  |  |  |  |  |  |  |  | x |  |  | o |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  |  | Cold 3 |  | [NAME]
 |  |  |  |  |  |  | Cook 1 |  |  |  |  |  | x |  |  | o |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | Butcher |  | [NAME]
 |  |  |  |  |  |  | [NAME] |  |  | o |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  |  |  |  | [NAME] |  | Bell Boy 4
 |  |  |  |  |  |  | Cook 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bell Boy 5
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night Manager
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night Duty 1
 |  |  |  |  |  |  | <<SELECT>> |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Night Duty 2
 |  |  |  |  |  |  | [NAME]
 | Total Staff On-Duty
 | WEEK |  | 4 |  |  |  |  |  |  | MONDAY |  |  |  |  |  | TUESDAY |  |  |  |  |  | WEDNESDAY |  |  |  |  |  | THURSDAY |  |  |  |  |  | FRIDAY |  |  |  |  |  | SATURDAY |  |  |  |  |  | SUNDAY
 |  |  |  |  |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift |  |  |  |  |  | Shift
 | Name |  |  |  |  |  | Position |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  |  |  | Exec. Chef |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  | o
 |  |  |  |  |  |  | HOLD
 |  |  |  |  |  |  | Pastry Chef |  |  |  |  |  | x |  |  |  |  |  | x |  |  | o |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x
 |  |  |  |  |  |  | Cook 1 |  |  | o |  |  |  |  |  | x |  |  |  |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x
 |  |  |  |  |  |  | [NAME] |  |  | x |  |  |  |  |  | o |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x |  |  |  |  |  | x
 |  |  |  |  |  |  | Cook 3
 |  |  |  |  |  |  | <<SELECT>>
 |  |  |  |  |  |  | <<SELECT>>
 |  |  |  |  |  |  | <<SELECT>>
 |  |  |  |  |  |  | [NAME]
 | Total Staff On-Duty