Defect + Works as Designed = X nos
=SUMPRODUCT(--($A$2:$A$14="Defect"),--($B$2:$B$14="Works as Designed"))

Defect + Fixed = X nos
=SUMPRODUCT(--($A$2:$A$14="Defect"),--($B$2:$B$14="Fixed"))

Document + Works as Designed = X nos.
=SUMPRODUCT(--($A$2:$A$14="Document"),--($B$2:$B$14="Works as Designed"))

Regards,
Stefi