I am working on a class register that records the attendance of students within a semester. I have been able to write the formula that counts Total Attendance for the semester (Jan-May) but I
am struggling to write a formula that counts total attendance for a specific month (eg Feb). See screenshot below and file attached. (PS the dates on the register are dynamic)
Class Register.PNG
Where do you specify which month you want attendance for? Where do you want the result to go?
Ideally I would want the attendance to be on another sheet where I can simply change the month from say Jan to Feb and it automatically show what was the attendance in that month.
But for simplicity sake the month could go in say F1 and the attendance for that month in F2.
I hope I am answered your questions properly.
Test my attachment.
Greetings.
hi maras… thank you very much for attempting to solve my problem.
Unfortunately your attachment produces a #Ref error and I suspect doesn't factor that the dates are dynamic and not static.
Just to be clear I wanted cell F1 to be a month eg Jan 2019 and cell F2 to be the total attendance for that month eg 35.
Last edited by TheGomzee; 03-14-2019 at 04:15 PM.
My solution includes dynamic date changes.
This can be a problem with the date system.
Could you attach a workbook with an error?
I will try to include your suggestions.
Greetings.
I am re-attaching the sheet you provided where it shows the #Ref also via screenshot
Class Register_maras.PNG
How are you counting attendance? Each day is broken into two sessions. Do they get 0.5 if they attend morning but not afternoon? Are we just counting "Present" and "Late"?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Just counting Present and Late. Basically each student has a possible of 2 attendances per day.
Ok I think I understand your wonderful formula now... It truly is wonderful
There was a slight language error I suspect in your formula where you had the date format of the text formula as "mmrrrr" but in my language it is "mmyyyy". This caused the #Ref error.
It seems to be working now. I will test it a few different ways and if it holds up I will close the thread as Solved.
Thank you for your patience and assistance.
Yes, you are right. This is the real reason for the error to appear.
Glad to help.
Greetings.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks