Thursday, December 22, 2011

yogi_Count Number Of CheckBoxes Selected in Google Form

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user Febin11 said:
Count number of check boxes selected in form
Ive created a form where the names of persons sharing a cost are selected i need to know how to count the number of people selected. in the spreadsheet the cell shows names with commas. 
in the following solution to the problem, I have names from checkboxes (in the Form, separated by commas,populated in column C of the Form Responses sheet. Then I inserted a computed column D where in I used an array formula to make the needed computation.