I have a massive worksheet with retailer data. What i want to do is count the total amount of retailers that sold any kind of flavored product. I can't do a simple Countif function cause some stores sold multiple kinds of flavored products. So how do I set up a function with roughly 12 ranges whereby I can count a store that sells the product if they sell but only counts it once across all those ranges?
Bookmarks