Spreadsheet: 782015d1653686977-conditional-formula-in-conditional-formatting-team-2-attendance-sheet-dph
Sheet: Monthly evolution

[NAME]
Count of Emma | Column Labels
 | 2020 | 2021 |  |  |  |  |  |  |  |  |  |  |  | 2022 | Grand Total
Row Labels | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan
Duty EHO |  |  |  | 2 | 2 | 2 | 1 | 3 | 1 |  |  |  |  |  | 11
Flexi |  |  |  |  |  | 1 | 1 |  | 1 |  |  |  |  |  | 3
Leave |  |  |  | 7 | 1 |  | 6 |  |  |  |  |  |  |  | 14
On Call |  |  |  | 2 | 1 | 1 | 1 | 2 | 2 |  |  |  |  |  | 9
RD | 4 | 17 | 14 | 14 | 15 | 16 | 14 | 15 | 16 | 15 | 14 | 16 | 17 | 2 | 189
Rosslare |  |  |  | 3 | 5 | 6 | 3 | 6 | 4 |  |  |  |  |  | 27
TOIL |  |  |  |  | 1 |  | 2 |  |  |  |  |  |  |  | 3
WFH |  |  |  | 3 | 5 | 5 | 2 | 5 | 4 |  |  |  |  |  | 24
(blank)
Grand Total | 4 | 17 | 14 | 31 | 30 | 31 | 30 | 31 | 28 | 15 | 14 | 16 | 17 | 2 | 280
Emma
Count of Shift | Column Labels
 | 2020 | 2021 |  |  |  |  |  |  |  |  |  |  |  | 2022 | Grand Total
Row Labels | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan
Duty EHO |  |  |  | 3 | 2 | 1 | 2 | 2 | 1 |  |  |  |  |  | 11
Flexi |  |  |  | 1 |  |  | 2 | 1 | 1 |  |  |  |  |  | 5
Leave |  |  |  | 3 |  |  | 2 | 3 |  |  |  |  |  |  | 8
On Call |  |  |  | 3 | 3 | 3 | 2 | 1 | 1 |  |  |  |  |  | 13
RD | 4 | 17 | 14 | 14 | 15 | 16 | 14 | 15 | 16 | 15 | 14 | 16 | 17 | 2 | 189
Rosslare |  |  |  | 2 | 4 | 5 | 2 | 4 | 4 |  |  |  |  |  | 21
WFH |  |  |  | 5 | 6 | 6 | 6 | 5 | 5 |  |  |  |  |  | 33
(blank) |  | 14 | 14 |  |  |  |  |  | 3 | 15 | 17 | 14 | 14 | 21 | 112
Grand Total | 4 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 23 | 392
[NAME]
Count of Shift | Column Labels
 | 2020 | 2021 |  |  |  |  |  |  |  |  |  |  |  | 2022 | Grand Total
Row Labels | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan
Duty EHO |  |  |  | 3 | 2 | 2 | 2 | 3 | 1 |  |  |  |  |  | 13
Flexi |  |  |  | 1 |  | 1 | 1 | 2 |  |  |  |  |  |  | 5
Leave |  |  |  | 1 |  |  |  | 2 |  |  |  |  |  |  | 3
On Call |  |  |  | 2 | 2 | 1 | 1 | 2 | 2 |  |  |  |  |  | 10
RD | 4 | 17 | 14 | 14 | 15 | 16 | 14 | 15 | 16 | 15 | 14 | 16 | 17 | 2 | 189
Rosslare |  |  |  | 6 | 3 | 3 | 6 | 2 | 4 |  |  |  |  |  | 24
WFH |  |  |  | 4 | 8 | 8 | 6 | 5 | 5 |  |  |  |  |  | 36
(blank) |  | 14 | 14 |  |  |  |  |  | 3 | 15 | 17 | 14 | 14 | 21 | 112
Grand Total | 4 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 23 | 392
[NAME]
Count of Shift | Column Labels
 | 2020 | 2021 |  |  |  |  |  |  |  |  |  |  |  | 2022 | Grand Total
Row Labels | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan
Duty EHO |  |  |  | 2 | 2 | 2 | 2 | 2 | 1 |  |  |  |  |  | 11
Flexi |  |  |  |  | 1 | 1 |  | 1 |  |  |  |  |  |  | 3
Leave |  |  |  | 3 |  |  |  | 1 | 1 |  |  |  |  |  | 5
On Call |  |  |  | 3 | 2 | 2 | 1 | 3 | 1 |  |  |  |  |  | 12
RD | 4 | 17 | 14 | 14 | 15 | 16 | 14 | 15 | 16 | 15 | 14 | 16 | 17 | 2 | 189
Rosslare |  |  |  | 6 | 3 | 3 | 5 | 4 | 4 |  |  |  |  |  | 25
WFH |  |  |  | 3 | 7 | 7 | 7 | 5 | 5 |  |  |  |  |  | 34
(blank) |  | 14 | 14 |  |  |  | 1 |  | 3 | 15 | 17 | 14 | 14 | 21 | 113
Grand Total | 4 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 23 | 392