counting two ranges for one criteria

[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

 

[Bob Phillips]

=SUMPRODUCT(--($A$2:$A$200="Equip Maint"),--(B$2:B$200="M"))

etc.