+ Reply to Thread
Results 1 to 2 of 2

Countifs - Criteria= contains value in "X:X"

  1. #1
    Registered User
    Join Date
    11-12-2014
    Location
    Iowa
    MS-Off Ver
    2010
    Posts
    1

    Countifs - Criteria= contains value in "X:X"

    I am trying to count all the cells that contain the contents of another cell. For example:

    Column B:
    Deep
    Limo Service
    Classic

    Column C:
    Classic 333
    Limo Service 1A1
    Classic 121
    Deep. Inc 111

    I want to count how many cells in column C contain a value listed in column B.

    Current formula, which obviously doesn't work: =COUNTIF(C:C,B:B)

    Hope this makes sense... Any help is greatly appreciated!!

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Countifs - Criteria= contains value in "X:X"

    Try

    =SUMPRODUCT(COUNTIF(C2:C5,"*"&B2:B4&"*"))

+ 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. Excel formula "COUNTIFS" problem with ">"
    By danngkb in forum Excel General
    Replies: 4
    Last Post: 06-19-2014, 02:32 AM
  2. [SOLVED] Possibly Easy: Making an "Other" with Countifs; "Not this, this, or this"
    By nscarritt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2014, 11:44 AM
  3. [SOLVED] Find multiple "text" criteria and return as ""Yes" in Matrix
    By bertrand82 in forum Excel General
    Replies: 11
    Last Post: 04-30-2012, 09:20 AM
  4. Replies: 10
    Last Post: 01-26-2012, 08:26 AM
  5. Replies: 0
    Last Post: 07-09-2009, 04:07 PM

Tags for this Thread

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