I have an Excel workbook in which I keep track of the duties of 60 employees over a 4 day convention. Each day has it’s own worksheet. The columns list the names of the employees. The rows highlight the tasks. In each cell I have the time in which they start the job. Is there a way to count how many employees are doing a specific task for a range of time? (Example: how many employees are working the registration desk between 10 a.m. and 12 p.m.) I tried COUNTIF but it would not do more than one criteria. Any help would be greatly appreciated.
