Counting Responses

[Danrella]

Hello lovely people,

I'm currently trying to figure out how I can count the different responses of my questionnaire. I do have a spreadsheet with all of my answers but I cannot post anything from the spreadsheet as the study still goes on. I already found out how to count simple answers but I also have questions where the participants can answer specific words as well as write something as part of their response.

I hope that I can show you with this example what I exactly mean:

The answer possibilities are:
Facebook, Twitter, Youtube
Also, the participants can select "Other" where they can write something, for example: Amazon, Hulu


Let's say three people filled out my questionnaire and I have the following data collected in the spreadsheet:

A1 represents in that case the Question that I have asked the participants.

A2: Facebook, Twitter
A3: Facebook, Youtube, Amazon
A4: Twitter, Hulu

So, as I said before I already know how to count how many times participants selected "Facebook", "Twitter" or "Youtube" but in that case I don't know how I can count every other answer BESIDES the ones that I gave the participants (Facebook, Twitter, Youtube). In this example, the answer should be 2.

Oh, almost forgot that the answers are separated with a comma and this formula doesn't work: =COUNTIF(A2:A10,"<>*txt*")

I feel like that the answer is probably pretty easy to figure out but I cannot find any helpful answer. Can someone please help me?

Thanks

[Pete_UK]

t's not entirely clear what you want, but you could use a formula like this in B2:

=IF(A2="","",LEN(A2)-LEN(SUBSTITUTE(A2,",",""))+1)

and then copy this down - it will give you the number of answers that occur in each cell of column A, so that you could then do, for example:

=COUNTIF(B:B,1)

and:

=COUNTIF(B:B,2)

and so on to find out how many single answers, then 2 answers etc. occur.

Hope this helps.

Pete

[Danrella]

Unfortunately your formula didn't work out that well.

But good news! I fixed it. Thank you for your help