Spreadsheet: 274604d1383159242-countif-function-not-working-main_spreadsheet
Sheet: August

Month | August |  |  |  |  |  |  |  | Week Commencing |  |  |  |  |  |  |  |  |  |  |  |  | Month | August |  |  |  |  |  |  |  | Week Commencing |  |  |  |  |  |  |  |  |  |  |  |  | Month | August |  |  |  |  |  |  |  | Week Commencing |  |  |  |  |  |  |  |  |  |  |  |  | Month | August |  |  |  |  |  |  |  | Week Commencing |  |  |  |  |  |  |  |  |  |  |  |  | Month | August |  |  |  |  |  |  |  | Week Commencing |  |  |  |  |  |  |  |  |  |  |  |  | Month | August |  |  |  |  |  |  |  | Week Commencing |  |  |  |  |  |  |  |  |  |  |  |  | Staff Daily Hours |  |  | Staff Daily Amount |  |  | StaffSICK |  |  | Staff Total
Location | HEADLEY PARK ROAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | HEADLEY PARK ROAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | HEADLEY PARK ROAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | HEADLEY PARK ROAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | HEADLEY PARK ROAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Location | HEADLEY PARK ROAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | DeanSICK |  |  | [NAME]
Day | Service user | 7-8am | 8-9am | 9-10am | 10-11am | 11-12am | 12-1pm | 1-2pm | 2-3pm | 3-4pm | 4-5pm | 5-6pm | 6-7pm | 7-8pm | 8-9pm | 9-10pm | OVERNIGHT |  |  |  |  | Day | Service user | 7-8am | 8-9am | 9-10am | 10-11am | 11-12am | 12-1pm | 1-2pm | 2-3pm | 3-4pm | 4-5pm | 5-6pm | 6-7pm | 7-8pm | 8-9pm | 9-10pm | OVERNIGHT |  |  |  |  | Day | Service user | 7-8am | 8-9am | 9-10am | 10-11am | 11-12am | 12-1pm | 1-2pm | 2-3pm | 3-4pm | 4-5pm | 5-6pm | 6-7pm | 7-8pm | 8-9pm | 9-10pm | OVERNIGHT |  |  |  |  | Day | Service user | 7-8am | 8-9am | 9-10am | 10-11am | 11-12am | 12-1pm | 1-2pm | 2-3pm | 3-4pm | 4-5pm | 5-6pm | 6-7pm | 7-8pm | 8-9pm | 9-10pm | OVERNIGHT |  |  |  |  | Day | Service user | 7-8am | 8-9am | 9-10am | 10-11am | 11-12am | 12-1pm | 1-2pm | 2-3pm | 3-4pm | 4-5pm | 5-6pm | 6-7pm | 7-8pm | 8-9pm | 9-10pm | OVERNIGHT |  |  |  |  | Day | Service user | 7-8am | 8-9am | 9-10am | 10-11am | 11-12am | 12-1pm | 1-2pm | 2-3pm | 3-4pm | 4-5pm | 5-6pm | 6-7pm | 7-8pm | 8-9pm | 9-10pm | OVERNIGHT |  |  |  |  | Christine |  |  | Christine |  |  | ChristineSICK |  |  | Christine
Monday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | VinSICK |  |  | [NAME]
 | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rose |  |  | Rose |  |  | RoseSICK |  |  | Rose
 | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | LisaSICK |  |  | [NAME]
 | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | DarrenSICK |  |  | [NAME]
Tuesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | JoshSICK |  |  | [NAME]
 | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lesley |  |  | Lesley |  |  | LesleySICK |  |  | Lesley
 | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lyn |  |  | Lyn |  |  | LynSICK |  |  | Lyn
 | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rita |  |  | Rita |  |  | RitaSICK |  |  | Rita
Wednesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | Julian
 | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia
 | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini
 | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen
Thursday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday | Julian
 | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia
 | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff Overnight |  |  | Staff Overnight Amount |  |  | StaffHOLS
 | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DeanO/N |  |  | [NAME] |  |  | DeanHOLS
Friday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ChristineO/N |  |  | Christine |  |  | ChristineHOLS
 | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VinO/N |  |  | [NAME] |  |  | VinHOLS
 | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | RoseO/N |  |  | Rose |  |  | RoseHOLS
 | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LisaO/N |  |  | [NAME] |  |  | LisaHOLS
Saturday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnights Worked |  |  | Saturday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnights Worked |  |  | Saturday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnights Worked |  |  | Saturday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnights Worked |  |  | Saturday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnights Worked |  |  | Saturday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnights Worked |  |  | DarrenO/N |  |  | [NAME] |  |  | DarrenHOLS
 | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JoshO/N |  |  | [NAME] |  |  | JoshHOLS
 | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hourly EST |  |  | LesleyO/N |  |  | Lesley |  |  | LesleyHOLS
 | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LynO/N |  |  | Lyn |  |  | LynHOLS
Sunday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnight Total |  |  | Sunday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnight Total |  |  | Sunday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnight Total |  |  | Sunday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnight Total |  |  | Sunday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnight Total |  |  | Sunday | Julian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overnight Total |  |  | RitaO/N |  |  | Rita |  |  | RitaHOLS
 | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sonia
 | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly EST |  |  |  | Shakini |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly EST
 | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maureen