dataAnalystB
New Member
- Joined
- Apr 16, 2014
- Messages
- 2
I am working with a very large data set where I need to be able to count the number of individuals for a particular position based on either their hired date or termed date. With smaller data sets, I can just sort by hired or termed date, then position, and manually count by selecting the group, but I feel there has to be a more efficient way of doing this can clicking and dragging. Not every line of the data set has a hired date, and of course some of those with hired dates do not have a termination date.
I would appreciate any suggestions on how to write a COUNTIFS statement that looks first at the position and then either Hired or Terminated to deliver the count for that position.
<tbody>
</tbody>
Thank you!
I would appreciate any suggestions on how to write a COUNTIFS statement that looks first at the position and then either Hired or Terminated to deliver the count for that position.
Hired | Termed | Position |
Position A | ||
1/15/2013 | 8/09/2013 | Position A |
7/17/2011 | 12/13/2013 | Position A |
Position B | ||
Position B | ||
8/19/2013 | Position B | |
1/16/2013 | 4/12/2013 | Position B |
3/20/2014 | Position B | |
5/22/2010 | 4/13/2014 | Position B |
7/23/2012 | Position C | |
8/23/2012 | 7/15/2013 | Position C |
Position C | ||
9/10/2009 | 3/25/2014 | Position C |
Position C |
<tbody>
</tbody>
Thank you!