• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Automatic Yearly Attendance


New Member
HI Friends,
I have a problem please help me to solve it. I have the monthly attendance reports and I want a summary of yearly. I am doing it manually and I want automatically,
Please help me to solve this. Attached a sample data for your reference



Excel Ninja
Hi ,

If you can ensure that the summary for each month will start from column AH onwards , and that the list of employees in each month will be in the same order , then the formula is simplified.

All you have to do is ensure that all the months are prior to the Summary tab , and you can have all the month tabs created right now , and fill in the data later.

See the attached file.