Could someone please resolve a problem for me. My thinking is to use Countif or Sumproduct, but it doesn't have to be (short of macros). I'm an advanced user of excel, but I don't know some of the more advance formula that could simplify this problem.
Column (E) is the Top 99 Managers in our company.
Column (F) was calculated to return the number of employees in the organization of the managers in Column (E).
Column (A) is each employee. Mgr 1 is the CEO, his code is A, so everyone reports to him and there are 1413 employees. The CEO has 5 direct reports (AB - Finance, AC - Legal, AD - Operations, AE - ILS, AG - HR). The umbrella goes down from there. Individual contributor codes end with "A" and Manager codes do not end with "A"
Column (B) indicates in the employees in Column (A) are a manager
Column (C) indicates in the ethnicity of the employees in Column (A)
Column (D) indicates in the gender of the employees in Column (A)
Using our CEO (Mgr 1) as an example I need to know how many of employees (EmpCode) in his org are Manager and Non Manager.
Out of the manager population I need to know how many are female and how many or non minority (not WH)
The VP of HR (AG) has (see A1399:A1415)
16 Employees (Cell F96)
4 Managers (indicated by “Yes”)
0 Minority Managers (EmpCode Cell A1402, A1406, A1408 and A1413 all have Ethnicity of WH)
1 Female Manager (D1402)