Questionaire reponses: Countif function

[rambochuck]

Hi I was wondering if someone could help me with my problem.

I am using excel to analyise questionaire responses for a project. As many of the questions have multiple choice answers, of which the respondant can choose one or more, I am having trouble using the countif function to count the number of times each answer was chosen. This is because in each cell is the letters of the answers chosen: e.g. ABCFH, and if I use countif(range,"B") even though B is in the cell it will return zero, presumably as excel is not searching for B inside whole words.

Can anyone think of a solution for this? Retyping the data is not really an option, so I need to use the countif function or similar

Many Thanks in advance

[daddylonglegs]

You can use "wildcards" with COUNTIF so to search for "B", even amongst other text, try

=COUNTIF(range,"*B*")

[rambochuck]

Thankyou, that seems to have done the trick - obvious now I think about it!

Cheers