Excel 2007 : Count phrases from drop down list

[Sally W]

Hi,

I've created a questionnaire using drop down lists (from a hidden worksheet) and now I am trying to count the different responses. I have tried using COUNTIF selecting the range of responses and quoting the response criteria, but I keep getting 0... E.g. =COUNTIF(b2:q2,"red")

Any help would be great...

[Bob Phillips]

Does the dropdown have extraneous spaces?

Try

=COUNTIF(b2:q2,"*red*")

[Sally W]

Perfect... Thanks!!