+ Reply to Thread
Results 1 to 4 of 4

Count "Criteria" in a Filtered List

  1. #1
    Registered User
    Join Date
    08-09-2016
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    3

    Count "Criteria" in a Filtered List

    Hi everyone,

    I have, in excel, a dataset of project activities (about 5,500 activities) where one of the columns are labeled "Critical Activity" and then in each row corresponding to the unique activity a simple "Yes" or "No" status is displayed.

    I have linked the data to an advanced filter, and as I filter I would like to count the number of critical activities in the filtered group.

    Does anyone have any suggestions on how to do this?

    Basically what I want is =COUNTIF("criteria range", "Yes") but with the ability to ignore invisible rows in the filtered list.

    Thank you in advance - hope the question was clear!

    Cheers!
    Last edited by Cotton Top; 08-09-2016 at 05:19 AM. Reason: Solved

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count "Criteria" in a Filtered List

    Try something like this...

    Assume the range is A5:A100.

    =SUMPRODUCT(SUBTOTAL(3,OFFSET(A5,ROW(A5:A100)-ROW(A5),0)),--(A5:A100="Yes"))

    You may need to replace the commas with semi-colons.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    08-09-2016
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    3

    Re: Count "Criteria" in a Filtered List

    Brilliant, Tony - That worked perfectly, thank you!

    Kind regards,

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Count "Criteria" in a Filtered List

    You're welcome. Thanks for the feedback!

+ 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] Count "ONLY" dates (Today/Tomorrow in filtered view viisable)
    By MBCMDR in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2015, 02:27 PM
  2. Replies: 1
    Last Post: 02-20-2015, 01:13 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 AM
  5. Replies: 1
    Last Post: 07-16-2010, 02:44 AM
  6. Replies: 0
    Last Post: 07-09-2009, 04:07 PM
  7. Replies: 7
    Last Post: 05-13-2006, 05:02 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