I have a file that contains a planner with dates in the lines and the roles of my team members in the columns.
I need to be able to count how many people are working per day and per role.
I need to get the sum per Role and for a specific date, with the date being a variable so I just create a cell with the date and change it there to easily filter for the different days. Basically, for the 13th, I would get "2" for Role 1 and 0 for Role 2.
Then, if I want to get the results for the 14th, I go and change it in the cell that I am using to store the date (remember it is a variable in my formulas) and I get 5 for Role 1 and 3 for Role 2.
Is it possible?
Thank you all for sharing your knowledge!