I have each week on different excel sheet. I want to create a look up that tell me how many people are schedule for specific shift on a specific date. bleow is the formula I am using on each single sheet.
=SUMPRODUCT(--($C$2:$C$280<=$C$206),--($K$2:$K$280>=$K$209),--(E2:E280=$E$201),--(A2:A280=$T$228))
I would like to create a new sheet that allows a user to change the date in a drop down. And number of people working is calculated.
Bookmarks