I'm a recruiter attempting to report various candidate metrics to a client. One metric I wish to report includes candidate 'Dismiss/Decline' reasons. These reasons are recorded under a 'Status' column and are selected among various options in a drop-down box). So I need to create a formula that tallies the number of candidates in each 'dismiss/decline' reason.
The status column looks like this presently:
Candidate Declined (Relocation)
Candidate Declined (Content with current employer)
Candidate Declined (Accepted other position)
Any suggestions on a viable formula would be greatly appreciated!!