counting two ranges for one criteria

  • Thread starter Thread starter Jules in IL
  • Start date Start date
J

Jules in IL

I am trying to find a function that will tell me how many males make up the
16 Equip Maint employees; how many are female and how many are minority.
I've been trying to count two ranges for one criteria - but it tells me i
have too many ranges. The Equip Maint is in the Dept column and the M is in
the Male column. I need to know the number of males, females and minorities
in each depatment.

Department Total Male Female Minority
Accounting 1
Equip Maint 16
HR 1
Mfg Mgmt 9
QC 2
General Plant 85
Warehouse 3
Total 117 0 0 0

Thanks - Jules
 
Back
Top