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     www.energyefficientbuild.com.   Jun 08, 2013
user Hooch180 (http://productforums.google.com/forum/?zx=cah13t9rrfiu#!category-topic/docs/spreadsheets/gw1BnbfCEQM)

How to sum selection from form checkboxes in spreadsheet

2 posts by 2 authors

 

 

Hello.

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?

--------------------------------------------------------------------------------------------------------------------