Attendance Sheet

Closed
Report
Posts
48
Registration date
Saturday October 27, 2012
Status
Member
Last seen
March 4, 2014
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
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 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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