Counting number of times different combinations occur
I am trying to figure out how many times certain combinations in an excel spreadsheet occur. For example, how many times in the data set does someone like the color Red, Blue, but not Yellow. I have attached a screenshot of the data set. Note: My actual problem has 10 different colors, not just 3. That is why I couldn't do it by hand, I need something that automates the process.