I’d say I’m an intermediate excel user but I have a not mastered using match, index and count if functions within each other. I have a table that has unique job titles in one column and unique shift labels for those jobs in the next column. For example, job title nurse in the first column and shift label “PM” for night shift. I am trying to count the number of PMs for the nurses as well as the other job titles. I want to do the same thing for “AM” shift.
Do you have any suggestions on how I can use one formula for this? Thank you!