My first question ever!
I've created a sheet with former-employee information. Each row a different employee. I need to use info from only two columns. Column J lists "term period" which is the month that an employee was terminated (Period 1, Period 2, etc.). Column L lists the "Supervisor" which is the direct supervisor of the former employee (Allen, Linda, Matt, etc.) I've filtered out many types of termination reasons that do not affect our turnover rate.
Now I'm in desperate need of a function to count the SUBTOTAL of employees "Allen" terminated in "Period 1", to show trend of terminations done per period by each manager.
I have this in place
=COUNTIFS(J:J,"Period 1",L:L,"Allen")
but it counts the hidden cells as well, and I'm trying to avoid that.
Please help :/
-E
Bookmarks