Microsoft Excel chart making help.

[willhub]

Hi.

For my analysis of my questionnaire for my dissertation I have worked out how to calculate how many people may have chosen number 5 (strongly agree) or number 1 (strongly disagree) using a COUNTIF calculation, but some of my other questions I am struggling how I should be working it out to then present it in a chart.

For example:

Basically I've had 145 responses, and for the question "what cycling disciplines do you undertake" and from those people have selected various different combinations.

What I'm wondering is how to do it for the cycling disciplines questions, as when I do for example =COUNTIF(C2:C146,"Track") It won't select track, it will only take the first word.

"Road, Mountain Bike"

The COUNTIF formula will only select road, when I want it to select "Mountainbike"

How do I do that?


Thanks.

 

[willhub]

Thanks

 

[willhub]

Oh also is it possible for it to add up any other answers, for example I've got some people saying things in that question such as "spinning class at gym", is it possible for it to detect any other answers like that and add them up, so like tying * * with nothing inbetween and it picks up anything other than the choices?

Cheers.