+ 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
    748

    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
    2,994

    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,402

    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
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,519

    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" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

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

    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