+ Reply to Thread
Results 1 to 6 of 6

Countifs Function, Words in a cell Criteria

  1. #1
    Registered User
    Join Date
    07-26-2013
    Location
    ca
    MS-Off Ver
    Excel 2007
    Posts
    28

    Countifs Function, Words in a cell Criteria

    I have strained my brain on this for a while, and i need help.

    Similar to a countifs function, but the problem resides where i need to match certain words in a cell to another.
    Attached is an example of what i am working on, it will make more sense when you see it.

    I tried using an array formula, but i had no success.Count if.xlsxCount if.xlsx
    Last edited by baca25; 10-28-2014 at 10:53 PM. Reason: Solved

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,884

    Re: Countifs Function, Words in a cell Criteria

    use
    =COUNTIF(B:B,"=*"&[@Project]&"*")

    but i get an answer of 4 in column B - as there are 4 occurrence of Cat Doorstop. in the column
    Why do you say 2?
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,676

    Re: Countifs Function, Words in a cell Criteria

    Maybe this in 2007:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    But I also get 4 for the first two answers.


    F
    G
    H
    I
    2
    Project
    Required to Completed Project
    Answers I need
    3
    Cat Doorstop.
    4
    <--
    2
    4
    Cat Jaida.
    4
    <--
    1
    5
    Cat KCDB Mounts.
    1
    <--
    1
    6
    "Other".
    5
    <--
    5



    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    07-26-2013
    Location
    ca
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Countifs Function, Words in a cell Criteria

    Thanks for the help guys. Just what I needed. The reason I needed 2 was because I needed it to match with the third column as well for "Yes". But that is easily done.

    Here is the formula: =COUNTIFS(B:B,"=*"&[@Project]&"*",C:C,"yes")

    and I needed:
    2
    2 (not 1)
    1
    5
    I had counted wrong.

    Thanks again.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,676

    Re: Countifs Function, Words in a cell Criteria

    You're welcome. Thanks for the rep.

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,884

    Re: Countifs Function, Words in a cell Criteria

    your welcome, thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using The Countifs Function With Three Criteria
    By samerz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-08-2014, 01:56 PM
  2. [SOLVED] COUNTIFS using multiple criteria - maybe an OR function?
    By Calder in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2014, 12:10 PM
  3. Need help using multiple criteria in second argument of CountIfs function
    By bclucas55 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-27-2014, 11:16 AM
  4. Criteria values in COUNTIFS function
    By jsnoz in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-21-2011, 12:46 PM
  5. Replies: 6
    Last Post: 02-21-2009, 08:13 PM

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