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 bel...