+ Reply to Thread
Results 1 to 3 of 3

COUNTIF search range of cells for multiple specific text.

  1. #1
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    COUNTIF search range of cells for multiple specific text.

    Hi All,

    I have a range (Lets say A1:A4) that has various text and numbers in each cell.

    NR: 99921 CR
    REQ: 21999 CR
    REQ: 38383
    NR: 38383

    I'm trying to do a countif formula that counts how many for "REQ:" AND "CR" in the same cell. I don't want to count ones with just "REQ" or just "CR" but must have both.

    Thanks,

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: COUNTIF search range of cells for multiple specific text.

    try
    =COUNTIFS(A1:A10,"*req:*",A1:A10,"*cr*")
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Forum Contributor
    Join Date
    10-15-2013
    Location
    Calgary, Alberta
    MS-Off Ver
    Excel 2007
    Posts
    218

    Re: COUNTIF search range of cells for multiple specific text.

    Perfect! Thanks!

+ 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] highlight when specific text appears multiple times in a range of cells - excel 2013
    By Onefynebarraza in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 10-14-2013, 09:06 AM
  2. countif on specific cells not a range.
    By pavlos in forum Excel General
    Replies: 2
    Last Post: 10-08-2012, 11:51 PM
  3. Replies: 1
    Last Post: 04-27-2012, 07:24 AM
  4. Getting range of cells with specific text colour, then using in a COUNTIF formulae
    By cheekyflash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2006, 08:58 PM
  5. [SOLVED] Countif for specific cells rather than a range ????
    By Renee - California in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-27-2005, 03:05 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