+ Reply to Thread
Results 1 to 7 of 7

Countif with specific text criteria

  1. #1
    Forum Contributor
    Join Date
    07-22-2008
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2007
    Posts
    129

    Countif with specific text criteria

    How many cells are there in B column where sentence ended with text "CP". I put formula RIGHT(text,[num_chars]) in C column then Countif with criteria "CP" and get the problem solved.

    But I'm seeking the solution in a cell which will bring result from Column B.

    Any formula?

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Countif with specific text criteria

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-22-2008
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2007
    Posts
    129

    Re: Countif with specific text criteria

    Thanks a lot

  4. #4
    Forum Contributor
    Join Date
    07-22-2008
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    2007
    Posts
    129

    Re: Countif with specific text criteria

    Quote Originally Posted by Vraag en antwoord View Post
    Please Login or Register  to view this content.
    Thanks a lot

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,139

    Re: Countif with specific text criteria

    Or with countif
    =COUNTIF(B2:B197,"*CP")

  6. #6
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Countif with specific text criteria

    Can go wrong if "cp" is elsewhere in the text.

  7. #7
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    13,139

    Re: Countif with specific text criteria

    In what way? It only counts the cell if it ends with CP

+ 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. Countif with 2 specific criteria
    By Smorg1966 in forum Excel General
    Replies: 1
    Last Post: 04-26-2017, 09:25 AM
  2. Help with CountIF on specific text
    By Ellen 2Excel in forum Excel General
    Replies: 3
    Last Post: 01-10-2017, 07:13 PM
  3. Replies: 2
    Last Post: 05-09-2016, 04:05 PM
  4. Using Countif with non-specific value criteria
    By cdmse in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-16-2016, 07:20 PM
  5. [SOLVED] countif - specific criteria
    By jambo2013 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-15-2015, 04:09 AM
  6. [SOLVED] COUNTIF visible cells matching specific criteria
    By MP1989 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2015, 06:07 PM
  7. Need help with COUNTIF function - with specific criteria search
    By robbertl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2012, 12:19 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