+ Reply to Thread
Results 1 to 2 of 2

counting Multiple answers in 1 cell + column

  1. #1
    help me i have an excel problem
    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
    Registered User
    Join Date
    02-09-2004
    Location
    The Netherlands
    Posts
    46
    You should use a wildcard, a *

    Your formula should look like this:
    =COUNTIF($B$1:$B$6,"=*magazines*") and the same for TV and radio.

+ 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