I created a form in Google Forms with three checkboxes for each question. Each group of checkboxes starts with the same repeating words (as in: Vata – xxxx, Pitta – xxxx, Kapha – xxxx). I want the total number for each one displayed at the bottom of the form, i.e. if they choose the "Vata" checkbox 10 times on the form, then "10" would be displayed at the bottom and the same for the other two checkboxes. It seems simple and probably is, but I can't figure it out!
Google-forms – Simple sum of checkboxes
google-forms
Related Topic
- Google-forms – have formulas in a Google Form, not just the worksheet
- Google-apps-script – Google Form with an alert
- Facebook – Google Form from Facebook Group
- Google-forms – Creating conditional sub-questions in Google Forms
- Google Forms – How to Set Up Conditional Branching with Checkboxes
- Google-forms – have a Google Forms automatically capture a user’s time zone
Best Answer
I am not sure I understand your question, but perhaps try something like:
assuming your responses are returned in ColumnC of your Responses Form and the formula are below existing responses and say in cells C27, C28 and C29.