Saturday, June 8, 2013

yogi_Count Instances Of Each Option Selected By Respondents to A Form Question

                                          Google Spreadsheet   Post  #1230
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jun 08, 2013
user Hooch180 (!category-topic/docs/spreadsheets/gw1BnbfCEQM)
How to sum selection from form checkboxes in spreadsheet
2 posts by 2 authors
I have sheet that contains data like this

Name | Surrname | Options

Where "Options" is string with options separated by ",". e.g. "A, B, D" (option A and B and D);

Example sheet
Bob | Smith | A, B, C
Jhon | Notsmith | A, C

There are total of 4 optins (A to D).
I would like to sum the number of A options throughout whole sheet.
In this example it would look like that:
A | 2
B | 1
C | 2
D | 0

How to do that?