Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61

    Unanswered: Count range of cells for occurance of a text value

    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

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    Just add a wildcard: =COUNTIF(A1:A40,"*a*")

    Hope that helps,

    Smitty

  3. #3
    Join Date
    Oct 2002
    Location
    BC Canada
    Posts
    61
    Originally posted by Smitty
    Just add a wildcard: =COUNTIF(A1:A40,"*a*")

    Hope that helps,

    Smitty

    Seems so simple once ya get the answer.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •