Count # of times "text" is in 1 column is specific date is in the other column

ann.acornacchio · #3 12-30-2016, 10:46 AM

Quote:

Originally Posted by Pecoflyer

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

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need help with conditional formatting & returning "Pass" / "Fail Results" in a Column N	mikey386	Excel	2	12-11-2014 01:14 PM
Set tables in email to default to "AutoFit Column Width"?	viper92283	Outlook	0	02-26-2014 03:31 PM
Can you turn off the "autofit column widths on update" by default?	New Daddy	Excel	0	11-23-2013 09:56 PM
Custom column in "List" view, show on Contact Card	phillyhy	Outlook	0	05-16-2012 11:13 PM
"First column" in word table page break border	mj1856	Word Tables	1	04-25-2012 03:21 AM