I would like to find a way to write a formula to accomplish the following:

I have a list of items in a tab of a workbook that has attributes across the top, with an X in the intersection if the item has that attribute. For example:

Items:

Apple

Table

Paperclip

Attributes:

Red

Wood

Small

The Apple might have an "X" in the intersection of Red and Small, and the Table might only have an "X" in the intsersection with Wood.

I have another tab with five drop downs that can either be blank, or one of the attributes. I want to create a formula that will return the number of items in the list that have an "X" for all the attributes selected in the drop down. Therefore if I selected only "Small" and left the other four blank, the formula might return 2, and if I then select the next drop down and select "Red" the formula would now return 1.

Any thoughts of how I could accomplish this? I am thinking of using a SUMPRODUCT and some sort of Index Match to find the value in the cells selected by the drop down. It seems like Index only returns a row though, and not a column. Any help is appreciated!