This is used for registration in a school during this Coronavirus situation.
Essentially teachers input the codes and a percentage is then calculated. This data is then analysed on another sheet showing the students absent for less than 61% of the week.
My issue is that if a teacher doesn't input a code for a student for the whole week a #DIV/0 code is given which affects the outcome of the sheet showing all the names.
Hopefully these pics will explain better...
Week 6. I put the 'O' in to see if that was the problem and it works...
Below is the formula for the adding of names from the class sheets to the sheet showing less than 61% attendance children.
Many thanks in advance. My apologies if this is something basic. ?
Essentially teachers input the codes and a percentage is then calculated. This data is then analysed on another sheet showing the students absent for less than 61% of the week.
My issue is that if a teacher doesn't input a code for a student for the whole week a #DIV/0 code is given which affects the outcome of the sheet showing all the names.
Hopefully these pics will explain better...
KG1C | |||||||||||||||||||||||||||||||||||||||||
Name | Total % | 22/03 | 23/03 | 24/03 | 25/03 | 26/03 | Week 1 % | 29/03 | 30/03 | 31/03 | 01/04 | 02/04 | Week 2 % | 05/04 | 06/04 | 07/04 | 08/04 | 09/04 | Week 3 % | 12/04 | 13/04 | 14/04 | 15/04 | 16/04 | Week 4 % | 19/04 | 20/04 | 21/04 | 22/04 | 23/04 | Week 5 % | 26/04 | 27/04 | 28/04 | 29/04 | 30/04 | Week 6 % | 28/04 | 29/04 | 30/04 | Days Present Total |
Tom | 100 | p | p | p | p | p | 100 | p | P | P | P | P | 100 | P | P | P | P | P | 100 | P | P | P | P | P | 100 | P | P | P | P | P | 100 | P | P | P | P | P | 100 | 30 | |||
**** | 63 | P | P | p | UA | UA | 60 | UA | p | UA | P | P | 60 | P | P | UA | P | P | 80 | P | P | P | UA | P | 80 | L | UA | P | P | UA | 60 | P | P | UA | UA | UA | 40 | 19 | |||
harry | 96 | l | p | p | p | l | 100 | p | l | P | P | P | 100 | P | P | P | P | P | 100 | P | P | P | P | P | 100 | AA | P | P | P | P | 80 | #DIV/0! | 24 | ||||||||
Bill | 62 | UA | UA | l | l | p | 60 | l | p | UA | UA | UA | 40 | AA | AA | P | P | P | 60 | P | P | P | P | P | 100 | P | P | P | UA | UA | 60 | O | 0 | 16 | |||||||
Ben | 100 | p | P | p | p | p | 100 | p | P | P | P | P | 100 | P | P | P | P | P | 100 | P | P | P | P | P | 100 | P | P | P | P | P | 100 | P | P | P | P | P | 100 | 30 |
Week 6. I put the 'O' in to see if that was the problem and it works...
Below is the formula for the adding of names from the class sheets to the sheet showing less than 61% attendance children.
Many thanks in advance. My apologies if this is something basic. ?