Counting instances where 2 parameters are true.

I would like to count all the number of A,B,C,D Fixtures types appear in a list simliar to the one shown above for every room such that it populates a schedule that looks like the one shown below.  

Any ideas on how to do that. I tried a COUNTIF statement but I need it to work for 2 parameters and it doesn't seem to count the whole table. do I have to set is as an array? here is the COUNTIF statement. 

Any and all suggestions help, thanks in advance.