Looking to solve this issue I'm trying to figure out. I need a formula to return the count of suppliers that have "Y" in their respective column.
Here is a small subset of data:
A1 = Vendor Name B1 = Minority Supplier
A2 = Goya B2 = Y
A3 = Goya B3 = Y
A4 = Monaco...