COUNT or IF Function for Multiple Text Criteria across rows and columns

[cbrust]

Please help!
Trying to semi-automate this counting process I have had to do manually by sorting and sorting and sorting then counting...

I am working with servers, business groups, etc, but to simplify, my spreadsheet is structured like this:

Type Color Sex Owner Rescued Shots
Dog red F Frank Y T-1
Dog brown F Jim Y T-1
Dog black M Mary Y T-2
Cat yellow F James Y R-1
Cat black M Bob N R-2
Cat brown M Sue Y T-2
Cat white M Laura N
Bird yellow F Sarah Y H-2
Bird white M N T-1
Mouse gray F Tom N T-2
Mouse white F Linda N R-1
Mouse black M Y R-2
Mouse brown M N
Mouse white M N H-1
Mouse black F Kate Y H-2

I need to create a few formulas that counts things like: how many mice... that are black... males... without names... have had either H-1 or H2 shots?

Please help if you can, thanks in advance!

 

[dyepaintball45]

try this:
=COUNTIFS(A1:A2,"=Mouse",B1:B2,"=black",C1:C2,"=M",D1:D2,"=""",F1:F2,"=H-*")
assuming type, color, sex, etc, are in that order and column header names.