yogi_Row By Row Count Of Total Number Of Choices and Row By Row Count Of Each Choice Made

                      Google Spreadsheet   Post  #1740
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-28-2014
post by Andyjst:
(https://productforums.google.com/forum/#!mydiscussions/docs/7dvJRO3wcFI)
Counting google form responses

Hello,

I am a google form that has a question that several options can be ticked, I am trying to filter that data so I can add up the number of times each box has been ticked individually. The countif function for text only works if I put in every options rather than separates.

e.g.

question with options A B C D, options A B and C are selected and displayed in the response form as A, B, C. I want to be able to count the amount of A's, B's C's etc. Countif only works when I do the following =COUNTIF(Sheet1!D2:D999, "A, B, C")

Thanks

**********************************************************************
This email is confidential and may contain copyright material of the John Lewis Partnership.
If you are not the intended recipient, please notify us immediately and delete all copies of this message.
(Please note that it is your responsibility to scan this message for viruses). Email to and from the
John Lewis Partnership is automatically monitored for operational and lawful business reasons.
**********************************************************************

John Lewis plc
Registered in England 233462
Registered office 171 Victoria Street London SW1E 5NN

Websites: http://www.johnlewis.com
http://www.waitrose.com
http://www.johnlewis.com/insurance
http://www.johnlewispartnership.co.uk

**********************************************************************