This question already has an answer here:
I have a large excel sheet with the following structure:
Gender | Answer ------- | ------- Male | A Female | B Male | A;C Female | A;B Female | B;D
What formula can I use to find out how many women answered, exclusively or not, B?
Thank you in advance,