Results 1 to 12 of 12

How to countif to partial text

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-04-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    298

    How to countif to partial text

    Is there a way to do a COUNTIF on just partial text?

    I know how to count how many cells in a column contain the text "cars" for example, but how would i write a formula that include cells with other text as well?

    For example if 55 cells have "cars" as a value
    and 20 cells have "fast cars" as a value

    I would want the formula to count 75.

    Basically, it needs to count how many cells cars appears in, in a specific column, regardless of whether its alone in the cell or part of a sentence.

    Thanks!
    Attached Files Attached Files
    Last edited by ks100; 12-19-2013 at 03:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. matching partial text within one cell to partial text within another
    By Solstice in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-03-2010, 09:13 PM
  2. COUNTIF for a partial value
    By Jonah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  3. [SOLVED] COUNTIF for a partial value
    By Jonah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. [SOLVED] COUNTIF for a partial value
    By Jonah in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. [SOLVED] COUNTIF for a partial value
    By Jonah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-03-2005, 09:05 AM

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