Attendance Sheet

Closed
ugn10 Posts 48 Registration date Saturday October 27, 2012 Status Member Last seen March 4, 2014 - Jun 19, 2013 at 12:08 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 20, 2013 at 10:49 AM
Hello friends,

Please help me for following issue.

I have created an attendance sheet in excel having 12 sheets (for all months like Jan, Feb, etc). in each sheets, all activities like number of present day, absent day, etc are counted. Now I want to add one more sheet that should have result of all sheets (say, total present day, absent day, etc of an executive month wise and it should be added at the end i.e. total present day, absent day etc of an executive in a year)

Please suggest how to do it.

You can find the sample format at http://speedy.sh/XxwzT/Sample.xlsx



1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 20, 2013 at 10:49 AM
Hi Ugn10,

Not sure what the issue is.

Looks to me like you can just use the SUM formula. Go across your sheets and click on the cells you would like to add to the SUM formula.

Best regards,
Trowa
0