Spreadsheet: 747830d1631716535-counting-text-across-multiple-rows-and-columns-sample3
Sheet: Location D

 | Go to Summary
Floor | Room | DEPARTMENT | MONDAY AM | MONDAY PM | TUESDAY AM | TUESDAY PM | WEDNESDAY AM | WEDNESDAY PM | THURSDAY AM | THURSDAY PM | FRIDAY AM | FRIDAY PM
1 | 1 | PAIN MANAGEMENT | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 2 | PAIN MANAGEMENT | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 3 | PAIN MANAGEMENT | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 4 | PAIN MANAGEMENT | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 5 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 6 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 7 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 8 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 9 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 10 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 11 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 12 | URGENT CARE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 13 | ORTHOPEDICS |  |  |  |  | Test | Test | Test | Test
1 | 14 | ORTHOPEDICS | Test | Test | Test | Test |  |  | Test | Test
1 | 15 | ORTHOPEDICS |  |  | Test | Test | Test | Test | Test | Test | Test | Test
1 | 16 | OB-GYN | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 17 | OB-GYN | Test | Test | Test |  |  |  | Test | Test | Test | Test
1 | 18 | ORTHOPEDICS |  |  |  |  | Test | Test | Test | Test
1 | 19 | ORTHOPEDICS |  |  |  |  | Test | Test | Test | Test
1 | 20 | ORTHOPEDICS | Test | Test | Test | Test |  |  | Test | Test
1 | 21 | ORTHOPEDICS | Test | Test | Test | Test |  |  | Test | Test
1 | 22 | ORTHOPEDICS |  |  | Test | Test | Test | Test | Test | Test | Test | Test
1 | 23 | ORTHOPEDICS |  |  | Test | Test | Test | Test | Test | Test | Test | Test
1 | 24 | OB-GYN | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 25 | OB-GYN | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 26 | OB-GYN | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 27 | OB-GYN | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 28 | OB-GYN | Test | Test | Test | Test |  |  | Test | Test | Test | Test
1 | 29 | ORTHOPEDICS | Test | Test | Test | Test | Test | Test | Test | Test
2 | 1 | INTERNAL MEDICINE | Test | Test | Test | Test | Test |  | Test | Test | Test | Test
2 | 2 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test |  | Test | Test
2 | 3 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test |  |  | Test | Test
2 | 4 | INTERNAL MEDICINE | Test | Test | Test |  | Test | Test | Test | Test | Test | Test
2 | 5 | INTERNAL MEDICINE
2 | 6 | INTERNAL MEDICINE | Test | Test | Test | Test | Test |  | Test | Test | Test | Test
2 | 7 | INTERNAL MEDICINE | Test | Test | Test | Test | Test |  | Test | Test | Test | Test
2 | 8 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test |  | Test | Test
2 | 9 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test |  | Test | Test
2 | 10 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test |  |  | Test | Test
2 | 11 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test |  |  | Test | Test
2 | 12 | INTERNAL MEDICINE | Test | Test | Test |  | Test | Test | Test | Test | Test | Test
2 | 13 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 14 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 15 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 16 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 17 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 18 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 19 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 20 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 21 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 22 | HEMATOLOGY/ONCOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 23 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 24 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 25 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 26 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 27 | HEMATOLOGY/ONCOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 28 | HEMATOLOGY/ONCOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 29 | HEMATOLOGY/ONCOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 30 | PODIATRY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 31 | ENT | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 32 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 33 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 34 | OPHTHALMOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 35 | PODIATRY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 36 | PODIATRY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 37 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 38 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 39 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 40 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 41 | ENT | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 42 | ENT | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 43 | OPHTHALMOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 44 | OPHTHALMOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 45 | OPHTHALMOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 46 | OPHTHALMOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 47 | OPHTHALMOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
2 | 48 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 1 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 2 | ENDOCRINOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 3 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 4 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 5 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 6 | ENDOCRINOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 7 | ENDOCRINOLOGY | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 8 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 9 | SHARED | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 10 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 11 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 12 | INTERNAL MEDICINE | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 13 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 14 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 15 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 16 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 17 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 18 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 19 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 20 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 21 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 22 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 23 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 24 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 25 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 26 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 27 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
3 | 28 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test