AnsweredAssumed Answered

Count and sort specific values of 6 checkbox/radiobutton fields

Question asked by NikVar on Nov 28, 2013
Latest reply on Nov 29, 2013 by philmodjunk

Title

Count and sort specific values of 6 checkbox/radiobutton fields

Post

     Hi there!

     I want some help to do this...

     I have a database of 1000 companies.

     I asked 6 different people to fill a questionnaire about those cpompanies, with 4 answers: "Yes", "No ", "Maybe", "Don't know"

     I have made 6 checkbox fields (one per person) and now I want to summarize their answers, to see how many "Yes", "No", "Maybe" and "Don't know" there are per comany. (I can also "convert" Checkbox to Radio Button fields)

     E.g.: The first company's answers are:  3 "Yes", 2 "No" and 1 "Maybe".  

     Now I want to count the ammount of "Yes" and sort those companies like this: First, the company with the bigger number of "Yes" etc...

     Thank you very much in advance!

Outcomes