I figured out a portion of my problem... Here is what I have so far:

=COUNTIFS(A:A,"=0?1-??",E:E, "=Annual")

The first range/criteria validates the correct team and employee status
throughout the entire column rather than a specified finite range. The second
range/criteria is for the employee's daily status. In this case, counting
only those who are on annual leave.

Each row of data represents a position in the organization. If a person's
name is in the name field then the position is filled. Otherwise, it is
vacant. I don't care about counting vacancies. The remaining problem: How do
I count only those rows that are filled by a person in addition to the other
criteria already listed?


"sabow71" wrote:

I manage a strength report for my employer that accounts for each employee
using a unique number assignment system. This system is designed to allow me
to identify which of nine teams an employee belongs to, identifying their
specific assignment within that team and also their employment status (i.e.,
contractor, intern, volunteer).

For example, I am 621-03. The "6" indicates which team I am on. The "2"
identifies my assignment (Quality Assurance). And the "1" indicates
employment status.

My strength report needs to provide an accountability breakdown for teams
and broken down further by employment status. Is there a function that can
extract a specific digit/character from a cell entry?

Currently, I am specifying cell ranges for each group. As the organization
expands, this will present an accuracy problem as valid cells are possibly
excluded from count.

How do I do this?