View Single Post
 
Old 12-30-2016, 08:06 AM
ann.acornacchio ann.acornacchio is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Dec 2016
Posts: 2
ann.acornacchio is on a distinguished road
Default Count # of times "text" is in 1 column is specific date is in the other column

Good Morning,

We have a workbook where we track information about incoming new hires that go through my department's orientation process.

I am trying to make it so that the excel sheet automatically tabulates the following things: RNs from NB, RNs from SOM, Total RNs, CCTs from NB, CCTs from SOM, Total CCTs, PMs from NB, PMs from SOM, Total PMs, UCs from NB, UCs from SOM, and Total UCs each from their respective worksheets all in one place on a separate worksheet.

I currently have 6 worksheets titled as follows: RN, CCT, PM, UC, Tabulation, & Misc Information. There are varying columns for each different worksheets but the first 10 are all the same: Last Name (A), First Name (B), Emp. #(C), Campus (D), CC# (E), Unit (F), Status (G), Transfer (H), Orientation Hours (I), & Orientation Start Date (J).

I have taken a basic Excel class and tried to write out what I need from the formula to make it work, but I am still having difficulties. I have has gotten as far as

=COUNTIF(RN!D1: D6,"NB")
which without identifiers would simply be =COUNTIF(-range-,"-text-")

I have attached images for clarification in case I was not specific enough, but please let me know if you need more images or information. I apologize that they are so big.

This is fine if I put in the ranges, but I am not the only person who uses this workbook and I worry that someone will add or remove a row and have it end up tabulating the wrong amount of people for each month.

Any guidance or suggestions are greatly appreciated. Thank you in advance for your response!!
Attached Images
File Type: jpg Excel Question Image 1.jpg (156.5 KB, 20 views)
File Type: jpg Excel Question Image 2.jpg (230.0 KB, 20 views)
Reply With Quote