analyzing comma separated data

I'm analyzing a survey. A column (which equals a question) offers multiple choice answers: A-F. The answers look like this:
A
A
A, F
B
B, C, D
A, C
A, C, D, F

So row "A, C, D, F" contains four answers in a single cell. How can I analyze how many answers of each type (A, B, C, D, E, F) are there in the entire column? I can make a column for each type of answer and then divide cells so that each answer gets a separate cell but I only know how to do that manually and it's lot of work.

First highlight the entire column then on the Data menu, use "text-to-columns". This will put the data in separate columns. You can then create a formula "=count" to count how many answers per row.

Hmmm you mean how many answers per column? When I do what you described, I get the same structure but divided into separate columns:
A
A
A F
B
B C D
A C
A C D F

If I count answers in the first column, I will get A and B answers mixed up. And besides it says in Help that =count can only be used to count numbers and these are letters...

Thanks but I'm getting 'The formula you typed contains an error'. I tried several different cell ranges so it's not that.

This time I got #N/A and under the exclamation mark it says Value Not Available Error.

Both formulas give 'The formula you typed contains an error' so I replaced commas with ;
After that, first formula gives #N/A and the second produces this mysterious result: 2 (just number two)
That's for this actual data:
A, B
B
D
A
A
G
A, B
A, F
A
and this formula:
=SUMPRODUCT(ISNUMBER(FIND({"A";"B";"C";"D";"E";"F";"G"};I3:I11))+0)

This returns '12' which is the number of all answers combined. I hope I made it clear that I'm looking for number of times each answer appeared. Like
A - 6
B - 3
C - 0
D - 1
...
If that wasn't clear, I apologize.

Thanks, this works!