Hi Gurus
Thanks for helping my every time!
I am familiar with the CountIFS function, however I don't get it to work with this scenario.
We have a team of 7 employees who locks up our shop every weekend and opens it again. I need to count how many times each employee opens and closes on the respective weekend days.
There is a tabel at the bottom which I need to summarize the counts.
Fridays we only count the CLOSING, Saturday the person who closed Friday opens Saturday and leaves at 11:00, then the second person works from 11:00 till closing, as well as the whole Sunday.
Thanks
Bookmarks