I have a sheet which hasd answers to a survey.

I want to tabulate toals for one answer that is a multiple choice
i.e. anser all that apply - cell value will contain a string 'a,b,c' etc.

or may be 'a' ...

I cannot use countif(a1:a40,"a") because it has to be exact - "a" only..

How can I get countif(range,contains "a") not equals "a"

thanks

Just add a wildcard: =COUNTIF(A1:A40,"*a*")

Hope that helps,

Smitty

Seems so simple once ya get the answer.

Thanks