I need to get some calculations done in excel and can't really understand if the function I am thinking about does the trick.
Appreciate any help you can provide. I have attached a file with example data of what I have and will explain what I am looking for.
I would like to know how many agents I have daily for each skill on each shift.
Thought about using the IF and COUNTIF function, but when I try to count the different agents existing on the same shift and with the same skill all gets messed up.
I am able to calculate only one of the criteria, even tried to get the IF function with ELSE, but wasn't able to get it.
I am going round in circles now and wasn't able to find a way to go around this calculation.
Thanks for any assistance provided.