Automatic Yearly Attendance

[jsmithjames03]

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

 

[herofox]

hello,you can to Use This

=SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!b3:b500"),$B3,INDIRECT("'"&Sheets&"'!"&CELL("address",AH$3)&":"&CELL("address",AH$500))))

 

[NARAYANK991]

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