Trying to interpret Survey Data - Countif ?

[jpnyc10021]

I'm trying to interpret survey data from Google Forms. I can use Google Sheets Or MS Excel for this analysis.
The question allowed a response via check boxes which allows for multiple responses.
The answers are listed in one cell, with a common between the answers if they chose more than one.
I'd like to sort the data by group (4 of them) and then show a pie chart (?) with the responses.

Example;
Column A / Column B
Red / Cow, Pig, Chicken
Red / Cow
Blue / Pig,Chicken
White / Cow,Chicken
White / Chicken
White /Chicken

Answer
Red -> Pie Chart with Cow X2, Pig X1
Blue -> Pie Chart with Pig X1, Chicken X1
White -> Cow X1, Chicken X3

I tried countif but had trouble with "," for some of the answers. Perhpas countifs.

I have about 10 questions with multiple Column B answers (around 50 in total) so text to columns would be a lot of work.
Apologies to the vegetarians among us.

[BadlySpelledBuoy]

Hi and welcome

Have a look at the attached with formulas in the yellow cells.

Does that help at all?

BSB

[jpnyc10021]

thank you! Will give it a try later today!

[wk9128]

Another option

Formula drag down and across

Please Login or Register  to view this content.

[jpnyc10021]

great - thank you!

[wk9128]

@jpnyc10021 You're Welcome. Glad to help . Thank You for the feedback and rep.