Hello
as images are impossible to work with, and the ones provided are not very clear, could you please post a small sample sheet ( Go Advanced - Manage attachments) containing some data and expected results ?
Also some explanation would help.


"RNs from NB" is not very explicit

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Good Morning,

Sorry if the images did not help. I have attached a rough version with fake data entered in it. On the one sheet I put in my current formula and, below it, what I would want the data to be.

I didn't think it mattered but RN, CCT, PM, and UC are just shortened job titles and SOM and NB are the codes for our 2 campuses. So when I say RNs from NB I am trying to count how many RNs from NB that were orientated that specific month. Is there any other information I can provide?

Attached Files

2017 Orientation Example.xlsx (21.8 KB, 15 views)