General discussion

Locked

Excel COUNTIF using time

By mark.guidetti ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel COUNTIF using time

by cyndeec In reply to Excel COUNTIF using time

You can't use COUNTIF with multiple criteria. To solve that problem you need to use an array formula. Look up "examples of commonly used formulas in help" and check the section on "counting the occurrences of multiple conditions" The formula for your problem would be something like this (modified for your worksheet of course!)where the first range contains your first criteria, the second range your second criteria, and if it matches, a "1" is added to the sum, otherwise a "0" is added. This type of formula must be entered on the formula bar with CTRL+SHFT+ENTER.

=SUM(IF(B62:B67="North",IF(C62:C67="West",1,0)))

Collapse -

Excel COUNTIF using time

by mark.guidetti In reply to Excel COUNTIF using time

Poster rated this answer

Collapse -

Excel COUNTIF using time

by snubber In reply to Excel COUNTIF using time

You can use the COUNTIF feature as long as you have a value that is constant either positive or negative. If you wanted to count all people who were working/putting in hours between 10am and 12pm, you would like to count all non zero's. So, COUNTIF(insert the range of cells here,>0). This will return a count of all people who had put in at least one or any part of an hour during that time frame. Please advise of usability.

Thanks,
Steve

Collapse -

Excel COUNTIF using time

by mark.guidetti In reply to Excel COUNTIF using time

Poster rated this answer

Collapse -

Excel COUNTIF using time

by mark.guidetti In reply to Excel COUNTIF using time

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums