• 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

    Hui...

  • 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

jsmithjames03

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
 

Attachments

  • Attendance test.xlsx
    32.9 KB · Views: 7
hello,you can to Use This
Code:
=SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!b3:b500"),$B3,INDIRECT("'"&Sheets&"'!"&CELL("address",AH$3)&":"&CELL("address",AH$500))))
 

Attachments

  • Attendance test1.xlsx
    38.3 KB · Views: 8
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.

Narayan
 

Attachments

  • EXCEL HELP (1).xlsx
    38 KB · Views: 15
Back
Top