function to find out count based on criteria.

Hi,
I have this table array,I want to find out how many vendors meets 4 out of 8 criterias given in the table.

Insert row below names and then: COUNTIF(C4:C11, "y") and then you'll get how many y's per vendor.

Then you can =COUNTIF(C3:BF3,">=4") to get your number