Hi all
I have an attendance tracker for which I need to count the individual who has attended which is in the form of a tick but if this individual sends a replacement I then need it to count the name (each entry represents a month so the below would be showing Jan, Feb, Mar).
But if the regular attendee can't attend and a representative can't attend this is shown as a cross and do not need this counted. example below: For the below I would need the count to be 2.
The reason for this is to get an average for the year for attendance. I got as far as adding a countif(s) to count the tick but wasn't sure how to count a name.
Many thanks
I have an attendance tracker for which I need to count the individual who has attended which is in the form of a tick but if this individual sends a replacement I then need it to count the name (each entry represents a month so the below would be showing Jan, Feb, Mar).
But if the regular attendee can't attend and a representative can't attend this is shown as a cross and do not need this counted. example below: For the below I would need the count to be 2.
The reason for this is to get an average for the year for attendance. I got as far as adding a countif(s) to count the tick but wasn't sure how to count a name.
Many thanks