Counting instances where 2 parameters are true.

Occasional Visitor


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.


1 Reply


=COUNTIFS('SOD Lighting Schedule'!$A$2:$A$2000, '# of Light Types Per Room type'!$B$2, 'SOD Lighting Schedule'!$B$2:$B$2000, A3)