+ Reply to Thread
Results 1 to 3 of 3

Need formula to COUNTIF specific TEXT, for only visible cells

  1. #1
    Registered User
    Join Date
    11-13-2015
    Location
    WA
    MS-Off Ver
    365 Enterprise
    Posts
    21

    Need formula to COUNTIF specific TEXT, for only visible cells

    My formula =COUNTIF(G6:G500,"*Yes*")

    Can someone help me find a formula that would count only the visible filtered cell? When filtered, I just want it to count the visible cells with text "Yes" . It would be great if SUBTOTAL formula could be combined, but I don't think that's possible.
    Last edited by Kirk3737; 01-12-2019 at 09:27 PM.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Need formula to COUNTIF specific TEXT, for only visible cells

    yeah, it's possible. it's explained in the file of my link below*Tips & Tutorials I Compiled, sheet 10
    something along:
    =SUMPRODUCT(SUBTOTAL(3,OFFSET(G6,ROW(G6:G500)-ROW(G6),))*(G6:G500="yes"))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    11-13-2015
    Location
    WA
    MS-Off Ver
    365 Enterprise
    Posts
    21

    Re: Need formula to COUNTIF specific TEXT, for only visible cells

    Awesome! Works perfect. Thank you benishiryo

+ 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] COUNTIF cells contain a specific word anywhere within the text string
    By RoundaboutCJP in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-18-2018, 12:38 PM
  2. Countif to include any number or specific text in merged cells
    By Brewdawg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2015, 06:29 PM
  3. [SOLVED] COUNTIF visible cells matching specific criteria
    By MP1989 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2015, 06:07 PM
  4. [SOLVED] Formula To Count Cells With Visible Text
    By avendi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-25-2014, 12:47 AM
  5. [SOLVED] COUNTIF search range of cells for multiple specific text.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2013, 06:38 PM
  6. Replies: 8
    Last Post: 07-14-2012, 10:22 AM
  7. Getting range of cells with specific text colour, then using in a COUNTIF formulae
    By cheekyflash in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2006, 08:58 PM

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