I have an attendance worksheet set up on a 3 month basis as below (no monthly total just each day)...
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
The 1 and 0 represent attendance. I have then set up a separate summary sheet for people to be able to see the total numbers of sessions a person has attended in in each month compared to the number allowed and then a 3 month summary
<colgroup><col span="2"><col span="3"><col><col><col><col span="3"><col><col><col></colgroup><tbody>
</tbody>
I thought i could use an index/match/sum to populate the Atten column in sheet 2 from the information in sheet 1, but i'm not sure how, i'd have to fit a sum into it as there are no totals in sheet 1. The names are not in the same order in sheet 2 as in sheet 1.
Does anyone have any ideas on how i can do it?
Thanks!
THURS | SUN | WED | THURS | SUN | WED | THURS | SUN | WED | THURS | SUN | WED | THURS | ||
Real Name | Team | 2-Jan | 5-Jan | 8-Jan | 9-Jan | 12-Jan | 15-Jan | 16-Jan | 19-Jan | 22-Jan | 23-Jan | 26-Jan | 29-Jan | 30-Jan |
Aillee MacDonald | Unrostered | 0 | 0 | |||||||||||
Ailsa Caine | Unrostered | 0 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
The 1 and 0 represent attendance. I have then set up a separate summary sheet for people to be able to see the total numbers of sessions a person has attended in in each month compared to the number allowed and then a 3 month summary
January | February | March | 3 month Jan-Mar | ||||||||||
Name | Team Status | Atten | Poss | % | Atten | Poss | % | Atten | Poss | % | Atten | Poss | % |
Antonia Lister | Belter | 5 | 5 | 100 | 2 | 5 | 40 | 0 | 0 | 0% | |||
Belinda Carr | Belter | 0 | 0 | 0% | |||||||||
Claudia Kaminski | Belter | 0 | 0 | 0% |
<colgroup><col span="2"><col span="3"><col><col><col><col span="3"><col><col><col></colgroup><tbody>
</tbody>
I thought i could use an index/match/sum to populate the Atten column in sheet 2 from the information in sheet 1, but i'm not sure how, i'd have to fit a sum into it as there are no totals in sheet 1. The names are not in the same order in sheet 2 as in sheet 1.
Does anyone have any ideas on how i can do it?
Thanks!