Super glad that you found this helpful! And this should be possible. If you could send me an email at info@spreadsheetlife.com, it will be easier for me to show you how to do this there.
What's the formula at 14:49 if you want to consider excuses, and sick the same as absent so that the percentage will be lower when you track it? (For example: 1 present, 1 sick, 1 excuse, 1 absent, you will only get 25% of the percentage rather than 75%)
Thank you so much it works ver well just wanted to know may i add my previous years data along with that like i have had attendance data of my classroom from 2020 to till year and i just wanted to add more sheet year wise like jan-2020 to dec-2020 upto 2024 Is it possible If it is then how can i make my different summaries for different calendar year and how i will make compile summary for all those years :) thanka mate
I'm glad that you got it all to work! 😊👍 You ask a great question, but there isn't a quicky easy answer unfortunately. What you are asking is definitely possible, but it will take some work. You can always add more sheets and rename them to Jan-2020, etc. However, the tricky part is updating the formulas on the summary page. Putting these formulas together is something that can't be explained with just a comment response unfortunately. If you're really interested in getting it to work this way, you are welcome to send me an email at info@spreadsheetlife.com, and we can discuss things further from there.
So glad you found this tutorial useful! If you'd like me to add custom functionality to this template or build a different type of tracker for you, you can always send me a request at this link. spreadsheetlife.com/custom-development/
this is very useful and clear to follow. thank you. but my percentage column is not properly working in the summary sheet. I have done exactly as you have shown but my C column (that reflects the D column in numbered percentage) shows up as ###### if there is any data on it. if there is no data, it just shows up as 0%. it works fine for the monthly sheets but I cant seem to find the problem for the summary sheet. could you please help?
Tell me more about what you mean by portfolio? As in a portfolio showcasing spreadsheets you've created as a demonstration of skills? Or something else?
I do my best to demonstrate the step-by-step process to make it simple to follow along, and I also try to include some advanced features so even seasoned Excel users have new things to learn. 😄👍
Thanks so much, I've been trying to make an attendance tracker for ages. Is there a way to separate the percentages (yes% or no%) or make the X negligible?
You're very welcome. 😊 I'm not sure what you mean by separate the percentages. Could you clarify a little for me? As for the X. If you never enter an X, and only enter Y and N, then the Attendance Tracker will still work just fine. Does this answer your question?
Hi Thanks for responding. Is there a way to show a percentage for y and a percentage for n instead of combing them as one. Hopefully that makes sense. Im new to excel 🫤🤯
Of course! Yes, this is possible. If you'd like, send me an email with your completed spreadsheet. I can add in those percentages for you on the Summary page, and then send it back to you with a brief explanation. How does that sound?
=IF(COUNTA(F4:AJ4)0,0,1-AM4/COUNTA(F4:AJ4)) What can I add to this formula in order to add a date range as a criteria as I want to make a weekly tracker?
I will do my best to help for sure! So as shown in the video, all X (or excused absences) will be counted as Yes values essentially for the percentage. Are you wanting to have the X count as a No instead towards the percentage?
Where are you located? Depending on your location, your Excel might require the use of semi-colons instead of commas as argument separators for your functions. Let me know if this helps.
I'm so glad to hear that this tutorial is helpful! For the formula, change the formula at 18:50 to the following. =IF(SUM(F6:H6)=0,0,F6/SUM(F6:H6)) This will make it so only Yes will count towards the percentage.
Loved the step by step. Planning to homeschool and this is exactly what I needed to keep track. ❤
Awesome! So glad you found this video helpful! 😊
This was a wonderful step by step guide. It works perfectly!! Thank you!
So glad you enjoyed it and successfully completed it! 😄👍
This is great! thanks a lot! can you also add if i want to see per month on the summary tab please. thanks
Super glad that you found this helpful!
And this should be possible. If you could send me an email at info@spreadsheetlife.com, it will be easier for me to show you how to do this there.
This is great! Going to start building and tweaking to fit my needs, but this is perfect! Thank you so much!
So glad that found this video and that it's helpful!! Good luck with the build!! 😄👍
What's the formula at 14:49 if you want to consider excuses, and sick the same as absent so that the percentage will be lower when you track it? (For example: 1 present, 1 sick, 1 excuse, 1 absent, you will only get 25% of the percentage rather than 75%)
Excellent question!
Change the formula to the following: =IF(COUNTA(F4:AJ4)=0,0,AL4/COUNTA(F4:AJ4))
Thank you so much it works ver well just wanted to know may i add my previous years data along with that like i have had attendance data of my classroom from 2020 to till year and i just wanted to add more sheet year wise like jan-2020 to dec-2020 upto 2024
Is it possible
If it is then how can i make my different summaries for different calendar year and how i will make compile summary for all those years
:) thanka mate
I'm glad that you got it all to work! 😊👍
You ask a great question, but there isn't a quicky easy answer unfortunately. What you are asking is definitely possible, but it will take some work. You can always add more sheets and rename them to Jan-2020, etc. However, the tricky part is updating the formulas on the summary page. Putting these formulas together is something that can't be explained with just a comment response unfortunately.
If you're really interested in getting it to work this way, you are welcome to send me an email at info@spreadsheetlife.com, and we can discuss things further from there.
Thank you so much. I love your content, keep going!
Thank you so much for your encouragement! I will keep it up the best I can!
Thank you so muchh👍
You are so welcome! 😊
Its very useful i did the same....tracker was superr....but i need to add sick leave and privileged leave kindly guide
So glad you found this tutorial useful!
If you'd like me to add custom functionality to this template or build a different type of tracker for you, you can always send me a request at this link. spreadsheetlife.com/custom-development/
this is very useful and clear to follow. thank you. but my percentage column is not properly working in the summary sheet. I have done exactly as you have shown but my C column (that reflects the D column in numbered percentage) shows up as ###### if there is any data on it. if there is no data, it just shows up as 0%. it works fine for the monthly sheets but I cant seem to find the problem for the summary sheet. could you please help?
I can help for sure. Could you email me your file or a screenshot at info@spreadsheetlife.com? This way, I can more easily take a look at it for you.
What's the reason, when I change the name section in the previous sheet, the sheet after it or halman after it also changes?
Hi there. I don't quite understand your question. Could you re-phrase it for me please?
Thank you!!!
This is so DOPE!
😄👍😊
Hey, may I use your Tutorials for my portfolio?
Tell me more about what you mean by portfolio? As in a portfolio showcasing spreadsheets you've created as a demonstration of skills? Or something else?
Would this work in the exact method and with thesame formulas in Google Sheet?
There would be some similarities, but there would also be a handful of differences. I'm sorry that's the case.
This is for advanced learners
I do my best to demonstrate the step-by-step process to make it simple to follow along, and I also try to include some advanced features so even seasoned Excel users have new things to learn. 😄👍
thanks alot
😄👍
Thanks so much, I've been trying to make an attendance tracker for ages. Is there a way to separate the percentages (yes% or no%) or make the X negligible?
You're very welcome. 😊
I'm not sure what you mean by separate the percentages. Could you clarify a little for me?
As for the X. If you never enter an X, and only enter Y and N, then the Attendance Tracker will still work just fine. Does this answer your question?
Hi Thanks for responding. Is there a way to show a percentage for y and a percentage for n instead of combing them as one. Hopefully that makes sense. Im new to excel 🫤🤯
Of course! Yes, this is possible. If you'd like, send me an email with your completed spreadsheet. I can add in those percentages for you on the Summary page, and then send it back to you with a brief explanation. How does that sound?
@@spreadsheetlife That is amazing.. thanks so much!!!🙂🙂
=IF(COUNTA(F4:AJ4)0,0,1-AM4/COUNTA(F4:AJ4))
What can I add to this formula in order to add a date range as a criteria as I want to make a weekly tracker?
What an interesting idea. To better answer your question, could you give me some more details about how you would like your weekly tracker to work?
good day can you help. I want to count the X for (excused ) with my percent
I will do my best to help for sure! So as shown in the video, all X (or excused absences) will be counted as Yes values essentially for the percentage. Are you wanting to have the X count as a No instead towards the percentage?
The =sum(jan:dec!al4) formula gives
me an error too! How can I fix it
Hmm...it's hard to say without more context. Send me your file at info@spreadsheetlife.com, and I can take a quick look at it for you if you'd like.
=IF(COUNTA(F4:AJ4)=0,0,-1-AM4/COUNTA(F4:AJ4)) it's not work on my excel
Where are you located? Depending on your location, your Excel might require the use of semi-colons instead of commas as argument separators for your functions. Let me know if this helps.
The =sum(jan:dec!al4) formula gives
me an error. Can someone advise?
You are welcome to send me an email with your file attached, and I can take a look at it for you.
How can I only calculate the Yes's for attendance?
In other words, are you asking how to write the formula so that only "Yes" counts and both "No" and "Excused" do not count?
@spreadsheetlife Yes, just need to record the Ys. Also this tutorial was incredibly helpful ❤
I'm so glad to hear that this tutorial is helpful!
For the formula, change the formula at 18:50 to the following.
=IF(SUM(F6:H6)=0,0,F6/SUM(F6:H6))
This will make it so only Yes will count towards the percentage.