Thursday, December 22, 2011

yogi_Count Number Of CheckBoxes Selected in Google Form

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. 
------------------------------------------
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.

2 comments:

  1. 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.

    ReplyDelete
  2. Hi BrianRodgers:

    Although 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

    ReplyDelete