+ Reply to Thread
Results 1 to 2 of 2

counting Multiple answers in 1 cell + column

  1. #1
    the6thlee
    Guest

    counting Multiple answers in 1 cell + column

    how do u count multiple values in the one cell and down the entire column?
    i want to count all magazines answers in column A1. i would like to get the
    answer (4) for magazines, (4) for tv, and (3) for radio. and it does not
    matter if the counting of the values, magazine,tv,radio, is answered in
    seperate cells. i tried the formula = COUNTIF(range, "value") but the
    formula doesnt not count the values if there are more than one value in the
    cell... see example below

    A1 A2
    1 magazines, tv, radio
    2 magazines
    3 tv, radio
    4 tv
    5 magazines, radio
    6 magazines, tv


  2. #2
    Bob Phillips
    Guest

    Re: counting Multiple answers in 1 cell + column

    Try variations on this formula

    =SUMPRODUCT(--(ISNUMBER(FIND("radio",A1:A100))))

    if you want case dependency, or

    =SUMPRODUCT(--(ISNUMBER(SEARCH("radio",A1:A100))))

    if not

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "the6thlee" <[email protected]> wrote in message
    news:[email protected]...
    > how do u count multiple values in the one cell and down the entire column?
    > i want to count all magazines answers in column A1. i would like to get

    the
    > answer (4) for magazines, (4) for tv, and (3) for radio. and it does not
    > matter if the counting of the values, magazine,tv,radio, is answered in
    > seperate cells. i tried the formula = COUNTIF(range, "value") but the
    > formula doesnt not count the values if there are more than one value in

    the
    > cell... see example below
    >
    > A1 A2
    > 1 magazines, tv, radio
    > 2 magazines
    > 3 tv, radio
    > 4 tv
    > 5 magazines, radio
    > 6 magazines, tv
    >




+ Reply to Thread

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