Forum Discussion
Solved
Count only Scheduled Employee's
I have a spread sheet of employee's and schedules. I need to be able to see how many are scheduled today, vs how many actually showed. Currently i'm using =COUNTIFS('Active Associates'!$G:$G,"1...
I think we're on the right path and i'm just having trouble putting all the pieces together.
The issue i'm having now is only counting the people scheduled for "Today" as indicated by the Day code in Q4
I've attached your previous file with different attempts at getting this to work.
The workbook below can give you a more directed approach to your solution. Thus, if i understand you. I have added the counts of those that overlap with 1st and also provided another row that calculates the Temp&Seasonal aspects. Well, you can give more insight as to what you need if this does not fit your requirement