My boss wants me to make a Sheet in an existing Attendance workbook that will add up all of the absences for a particular day. January 1st is in Cell B1 on all 65 sheets. If someone was absent that day we insert an appropriate letter (S-sick, V-vacation,etc.) is there an easy-ish way to add up each days absences on a Master sheet in that workbook, for each day? Please help me.
Last edited by jakeisbill; 03-16-2012 at 09:48 AM.
Attach a sample workbook.
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- Mark your post SOLVED if it has been answered satisfactorily:
- Select Thread Tools (on top of your 1st post)
- Select Mark this thread as Solved
Here is a smaller version of the file. I belive the larger file has 46 name sheets. Ideally I would like to have it auto populate the entire calendar with the number of Employees Present each Day. Thanks a ton.
so if there are letters in any cell then it will be considered as absence?
Correct Kelshaer. If they show up to work the Cell is Blank. I tried to do a COUNTBLANK function but found that is doesn't work in 3d. Also, our IT professional does not allow for 3rd Party Add-ins. So it has to be programmed the old fashioned way.
Here you Go.
Please Login or Register to view this content.
Re: Help With COUNTBLANK across Multiple Sheets
Thank You So much. It works like a Charm. You are a life saver.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks