+ Reply to Thread
Results 1 to 4 of 4

countif wildcards?

  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    315

    countif wildcards?

    I'm using the countif formula to look up certain keywords in a column(=COUNTIF(Sheet1!G1:G1170,"George"). In my column, there will be different entries other than just "George". There may be George Smith, George Jones, George Thompson, etc...etc...
    Is there a better formula that will return a result for all "george's". Right now, it doesn't return anything because of the various George's.

    Thanx.

  2. #2
    Chip Pearson
    Guest

    Re: countif wildcards?

    Try

    =COUNTIF(A1:A10,"*George*")


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Ltat42a" <Ltat42a.208vcm_1134924000.5717@excelforum-nospam.com>
    wrote in message
    news:Ltat42a.208vcm_1134924000.5717@excelforum-nospam.com...
    >
    > I'm using the countif formula to look up certain keywords in a
    > column(=COUNTIF(Sheet1!G1:G1170,"George"). In my column, there
    > will be
    > different entries other than just "George". There may be George
    > Smith,
    > George Jones, George Thompson, etc...etc...
    > Is there a better formula that will return a result for all
    > "george's".
    > Right now, it doesn't return anything because of the various
    > George's.
    >
    > Thanx.
    >
    >
    > --
    > Ltat42a
    > ------------------------------------------------------------------------
    > Ltat42a's Profile:
    > http://www.excelforum.com/member.php...o&userid=24735
    > View this thread:
    > http://www.excelforum.com/showthread...hreadid=494440
    >




  3. #3
    Bob Umlas
    Guest

    Re: countif wildcards?

    =COUNTIF(G1:G1170,"*george*")
    Bob Umlas
    Excel MVP

    "Ltat42a" <Ltat42a.208vcm_1134924000.5717@excelforum-nospam.com> wrote in
    message news:Ltat42a.208vcm_1134924000.5717@excelforum-nospam.com...
    >
    > I'm using the countif formula to look up certain keywords in a
    > column(=COUNTIF(Sheet1!G1:G1170,"George"). In my column, there will be
    > different entries other than just "George". There may be George Smith,
    > George Jones, George Thompson, etc...etc...
    > Is there a better formula that will return a result for all "george's".
    > Right now, it doesn't return anything because of the various George's.
    >
    > Thanx.
    >
    >
    > --
    > Ltat42a
    > ------------------------------------------------------------------------
    > Ltat42a's Profile:
    > http://www.excelforum.com/member.php...o&userid=24735
    > View this thread: http://www.excelforum.com/showthread...hreadid=494440
    >




  4. #4
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    315
    Quote Originally Posted by Chip Pearson
    Try

    =COUNTIF(A1:A10,"*George*")


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com


    "Ltat42a" <Ltat42a.208vcm_1134924000.5717@excelforum-nospam.com>
    wrote in message
    news:Ltat42a.208vcm_1134924000.5717@excelforum-nospam.com...
    >
    > I'm using the countif formula to look up certain keywords in a
    > column(=COUNTIF(Sheet1!G1:G1170,"George"). In my column, there
    > will be
    > different entries other than just "George". There may be George
    > Smith,
    > George Jones, George Thompson, etc...etc...
    > Is there a better formula that will return a result for all
    > "george's".
    > Right now, it doesn't return anything because of the various
    > George's.
    >
    > Thanx.
    >
    >
    > --
    > Ltat42a
    > ------------------------------------------------------------------------
    > Ltat42a's Profile:
    > http://www.excelforum.com/member.php...o&userid=24735
    > View this thread:
    > http://www.excelforum.com/showthread...hreadid=494440
    >
    Thanx Chip....that works great!

    JF

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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