Results 1 to 6 of 6

Counting multiple values in one cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2009
    Location
    NY, NY
    MS-Off Ver
    Excel 2003
    Posts
    2

    Counting multiple values in one cell

    So, I have a spreadsheet with data from a survey. There are 375 respondents (rows) and 26 questions (columns). I use COUNTIF in order to figure out the frequency of responses and SUMPRODUCT to do some finer analysis.

    Here's my problem, some of the questions have multiple valid responses. In those cases the data was entered into the same cell. So I have a column that looks like this:

    1,4
    2
    1
    3,12
    1,11
    8,
    3,14,9

    And so on....

    I can't figure out how to count the number of "1"s. It would be much easier if the responses could only be 1-9, but unfortunately they can be 1-20.

    So far, I've come up with:

    =SUM(IF(ISNUMBER(FIND("1",A1:A375)),1,0))
    But obviously that doesn't work or I wouldn't be here.

    For the above example it returns 5, when the answer should be 3

    Any ideas? Thanks in advance!
    Last edited by andrewsomething; 05-02-2009 at 12:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1