+ Reply to Thread
Results 1 to 5 of 5

Countif with text and wildcards

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Countif with text and wildcards

    hI GUYS,

    I have an issue where i`m trying to write the follwing text in cell J1:


    ="Auto vetting enabled: " & COUNTIFS(E:E, "Y", F:F, *Active*)

    Count all the cells from column, which have a "Y" and are "active" - as indicated in column F. I need the wildcard symbol incase there are different contents with the word active. ss attached.

    pls help!

    THANKs.

    R.
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Countif with text and wildcards

    Perhaps
    ="Auto vetting enabled: " & COUNTIFS(E:E, "Y",F:F,"*Active*")

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Countif with text and wildcards

    Maybe?

    ="Auto vetting enabled: " & COUNTIFS(E:E, "Y",F:F, "*Active*")

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Countif with text and wildcards

    Did you try this?

    ="Auto vetting enabled: " & COUNTIFS(E:E, "Y", F:F, "*Active*")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Countif with text and wildcards

    thank you all!

+ 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. Countif for dates with wildcards
    By Newsome79 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-16-2017, 11:36 AM
  2. [SOLVED] Using Wildcards in CountIf
    By SilverBullet17 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-16-2017, 06:21 AM
  3. CountIF and Wildcards
    By Justmegan93 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-09-2014, 09:05 AM
  4. [SOLVED] COUNTIF Using Wildcards
    By JoeJaycee in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2012, 02:52 PM
  5. Countif with wildcards
    By seanjoe in forum Excel General
    Replies: 4
    Last Post: 06-02-2010, 09:04 AM
  6. is it possible to use countif with a cell ref and wildcards?
    By videot96 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-25-2009, 05:10 PM
  7. countif wildcards?
    By Ltat42a in forum Excel General
    Replies: 3
    Last Post: 12-18-2005, 12:59 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