+ Reply to Thread
Results 1 to 3 of 3

I have to count nonblank values in a filtered list by multiple criteria. Help!

  1. #1
    Registered User
    Join Date
    01-25-2021
    Location
    North Florida
    MS-Off Ver
    18.2008.12711.0
    Posts
    49

    I have to count nonblank values in a filtered list by multiple criteria. Help!

    I'm trying to take conditional counts on a filtered range. It's for a dynamic tool that others will be using, a table that updates values based on the filters applied to the variables.

    Just the ranges I'm working on right now are PROGRAM NAME (I2:I7238), ENROLL DATE (M2:M7382) and GRADUATION DATE (O2:O7382). Right now, Clients Entered is reading correctly both filtered and unfiltered by using =SUMPRODUCT((I2:I7382="Program A")*(SUBTOTAL(103,OFFSET(I2,ROW(I2:I7382)-MIN(ROW(I2:I7382)),0)))) in the Clients Enrolled cells. The total Completed count cell uses =SUBTOTAL(102,O2:O7382). Now what I need is a formula that will give me the count of nonblank cells in O2:O7382 per program. Maybe it's something simple but I can't figure out how to get that column to return counts when Column I equals a specific value AND when Column O is nonblank for just the visible rows.

    A shortened version with the current formulae and problems explained are in the example Excel sheet I've attached.


    Any help is greatly appreciated, I'm under the gun on this. Thanks.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    11-21-2013
    Location
    zimbabwe
    MS-Off Ver
    Excel 2003
    Posts
    124

    Re: I have to count nonblank values in a filtered list by multiple criteria. Help!

    Just a little change in your formula as follows
    To Enrolled cells
    Please Login or Register  to view this content.
    Then drag it to the right for Completed cells
    Hope this helps

  3. #3
    Registered User
    Join Date
    01-25-2021
    Location
    North Florida
    MS-Off Ver
    18.2008.12711.0
    Posts
    49

    Re: I have to count nonblank values in a filtered list by multiple criteria. Help!

    Yes, it looks like that 103 function was the problem. Thank you!

+ 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. Replies: 5
    Last Post: 01-31-2021, 01:46 PM
  2. Count values based on multiple (three) criteria from drop down list
    By hkaric in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-10-2020, 04:13 AM
  3. [SOLVED] count up multiple criteria in multiple ranges - filtered data
    By jenson1234 in forum Excel Formulas & Functions
    Replies: 42
    Last Post: 10-24-2019, 10:41 AM
  4. Count Distinct Values With A Criteria In A Filtered List
    By JonnyBoy333 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2019, 02:52 AM
  5. [SOLVED] Count Values in Filtered List / Return Final Row in a Filtered List
    By HarryGreenwood in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-22-2018, 06:52 AM
  6. How to count unique values in filtered list?
    By Cayenne in forum Excel Charting & Pivots
    Replies: 14
    Last Post: 10-23-2014, 04:58 PM
  7. [SOLVED] Count nonblank cells with multiple criteria
    By Daniel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-17-2005, 06:10 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