ok, here is the situation in Sheet 1 Column B I have the date that a person arrived. In Sheet 1 Column C I have the time the person arrived. In Sheet 3 Column A I have the the date, in Sheet 2 Column C I have the time the shift started and in Sheet 3 Column C I have the time the shift ended. In Sheet 3 Column D I have a number which indicates how many people were on that shift, some shift times overlap.
What I need to do is count how many people were working when the customer arrived and place that number in a column on sheet 1.
This is what I came up with but does not work properly.
=SUMIFS(Sheet3!$D$1:$D$605,Sheet3!$A$1:$A$605,"="&Sheet1!B2,Sheet3!$B$1:$B$605,"<="&Sheet1!C2,Sheet3!$C$2:$C$606,">="&Sheet1!C2)
Can someone give me some guidance?
Bookmarks