Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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.
------------------------------------------
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.
How could I tally the number of times a certain name shows up in a column? In your example, how many times "Sue" is checked in contained/checked in C:C.
ReplyDeleteHi BrianRodgers:
ReplyDeleteAlthough what you asked is an extension of the problem in this post, I have posted a solution to a bit more generalized problem in my following blog post:
yogi_Check Whether A Specified Name Was Selected (and how many times) In Google Form CheckBoxes
http://yogi--anand-consulting.blogspot.com/2012/12/yogicheck-whether-specified-name-was.html
Please check it out and let me know how it goes.
Make It A Great One.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com