https://dl.dropbox.com/u/5415677/customer-service-dashboard-v1.xlsm
Top right is a help button you click, and help comments appear. Would anyone be willing to coach me on how to do such, please?
In addition, can anyone share how to make the rounded border on the table?
Thank you.
@Luke M: Thank you for attempting to open. I apologize for the difficultly. SUMIF/COUNTIF is a great idea. Thank you for the input.
@Raja: Thank you for taking the time to work my sample. It made understanding very simple. Thank you.
@bobhc: Thank you for modifying my example as well...
Thank you for taking the time to view my post.
File: https://dl.dropbox.com/u/5415677/Attendance.xlsx
Is there any way to use vlookup to calculate the total amount of absent hours for each year for an individual?