Is there a way to count the number of times a person is scheduled to work at a specific time? I have a calendar in Excel by month, with the employes scheduled at 2 time slots per day, throughout the omonth. and I have tried all versions of countif to return the number of shifts per employee and get no actual data, so I am counting them manually. I have tried the Countifs and it wont work. Is there another formula to help?

=COUNTIFS(A4:N39,"="&TIME(9,0,0),A4:N39,P6)

P6 = the employee name, the month grid is A4:N39.

Help? Thank you