+ Reply to Thread
Results 1 to 3 of 3

Using COUNTIF with text from another cell

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    3

    Using COUNTIF with text from another cell

    This is my current code:

    =COUNTIF(C$8:C$31,"=A50*")

    A50, should be a letter from another cell. For example right now A50 is A. The code used to look like this, but I want to make it easier for multiple letters. =COUNTIF(C$8:C$31,"=A*")

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

    Re: Using COUNTIF with text from another cell

    Try

    =COUNTIF(C$8:C$31,A50&"*")

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Using COUNTIF with text from another cell

    Dunno if I understood this correctly.

    Try

    =COUNTIF(C$8:C$31,A50&"*")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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] PLEASE HELP: COUNTIF text is in the cell
    By sharmane3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2014, 03:32 PM
  2. Using cell data as partial text search with COUNTIF
    By CarV in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2014, 12:29 PM
  3. [SOLVED] Countif cell contains this text string, cell does not have to equal this value exactly.
    By ThomasCarter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2012, 09:57 AM
  4. [SOLVED] Countif to search for text in a cell
    By holycowbanana85 in forum Excel General
    Replies: 3
    Last Post: 07-26-2012, 03:56 AM
  5. COUNTIF text where there is more than one word in a cell
    By Abi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-20-2005, 07:10 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