Spreadsheet: 797194d1663757655-x-out-of-y-in-excel-formula-needed-attendance-log-version-2022
Sheet: Sheet1

Key
Y | Attended
Y | Attended Special meeting
N | Apologies received
A | Absent (no apologies received)
 | See comment - reason for part/non-attendance
 | meeting cancelled
 | not applicable - term not started/or term ended
 |  |  |  | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 |  |  |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  |  |  |  |  | 2023 |  |  |  |  |  |  |  |  |  |  |  | Total Attendance
Committee / Board | First Name | Surname | Title | JAN | FEB | MAR | APR | APR | MAY | MAY | JUN | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEPT | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Board | Name | 9 | Chair |  |  | Y | Y |  |  |  | Y |  | Y |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula isnt working
Board | Name | 4 | Member |  |  | Y | Y |  |  |  | Y |  | Y |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula isnt working
Board | Name | 6 | Member |  |  | Y | Y |  |  |  | Y |  | Y |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula isnt working
Board | Name | 7 | Member |  |  | Y | Y |  |  |  | Y |  | Y |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | N |  |  | Y |  |  | Y |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula isnt working
Board | Name | 11 | Member |  |  | Y | Y |  |  |  | Y |  | Y |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula isnt working
Board | Name | 10 | Member |  |  | Y | Y |  |  |  | Y |  | Y |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula isnt working
Board | Name | 5 | Member |  |  | Y | Y |  |  |  | Y |  | Y |  | Y |  |  | Y |  |  | Y |  |  | N |  |  | Y |  |  | N |  |  | Y |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula isnt working
Board | Name | 2 | Member |  |  | Y | Y |  |  |  | Y |  | Y |  | Y |  |  | N |  |  | N |  |  | A |  |  | Y |  |  | Y |  |  | N |  |  | N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula isnt working
Board | Name | 1 | Member |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | Y |  |  | N
Board | Name | 3 | Member |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | N
Audit & Risk | Name | 7 | Member |  | Y |  |  |  | Y |  |  |  | Y |  | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  | N |  |  | Y
Audit & Risk | Name | 2 | Member |  | N |  |  |  | Y |  |  |  | Y |  | Y |  | N |  |  |  | Y |  | N |  |  |  | Y |  | Y |  |  | Y |  |  | Y |  |  |  | Y
Audit & Risk | Name | 3 | Member |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y
Audit & Risk | Name | 8 | Member |  | N |  |  |  | Y |  |  |  | Y |  | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  | Y |  |  | N
Remuneration | Name | 9 | Chair |  | Y |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |  |  | Y
Remuneration | Name | 11 | Member |  |  |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |  |  | Y
Finance | Name | 6 | Chair |  | Y |  | Y |  | Y |  |  |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  | Y |  |  | Y
Finance | Name | 10 | Member |  | Y |  | Y |  | Y |  |  |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  | Y |  |  | N
Finance | Name | 11 | Member |  | Y |  | Y |  | Y |  |  |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  | Y |  |  | Y |  |  | Y
Noms & Gov | Name | 9 | Chair | Y | Y |  | Y | Y |  |  |  |  | Y | N | Y | Y |  | Y | Y |  |  | Y |  |  | Y |  |  |  | Y |  |  | Y |  | Y
Noms & Gov | Name | 4 | Member | N | Y |  | Y | Y |  |  |  |  | Y | Y | Y | Y |  | Y | Y |  |  | N |  |  | Y |  |  |  | Y |  |  | Y |  | Y
Noms & Gov | Name | 1 | Member |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  | Y |  |  |  | Y |  |  | Y |  | Y
Noms & Gov | Name | 5 | Member |  | Y |  | Y | Y |  |  |  |  | Y | Y | Y | Y |  | Y | Y |  |  | Y |  |  | Y |  |  |  | Y |  |  | Y |  | A
Council AGM | Name | 9 | Attendee |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y
Council AGM | Name | 4 | Member |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  |  |  |  |  |  | N
Council AGM | Name | 6 | Member |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y
Council AGM | Name | 7 | Attendee |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  |  |  |  |  |  | N
Council AGM | Name | 11 | Attendee |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y
Council AGM | Name | 10 | Attendee |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y
Council AGM | Name | 5 | Attendee |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  |  |  |  |  |  | N
Council AGM | Name | 2 | Attendee |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  |  | N |  |  |  |  |  |  |  |  |  |  |  | Y
Council AGM | Name | 1 | Attendee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |  |  |  |  |  |  | Y
Council AGM | Name | 3 | Attendee |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
Crisis Committee | Name | 9 | Chair |  |  |  | Y | Y | Y | Y | Y | Y |  |  |  |  | Y
Crisis Committee | Name | 6 | Member |  |  |  | Y | Y | Y | Y | Y | Y |  |  |  |  | Y