+ Reply to Thread
Results 1 to 3 of 3

How to only count rows that are current (fulfil a criteria)

  1. #1
    Registered User
    Join Date
    01-12-2021
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    65

    How to only count rows that are current (fulfil a criteria)

    Hi,
    I only want to count client who are on the ACTIVE waiting list. Once the referral is complete, the row greys out and I do not want these rows to be counted in the "Number of clients waiting" table. I am wondering what formula would do this?

    Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-09-2014
    Location
    Leeds, England
    MS-Off Ver
    Excel 365
    Posts
    50

    Re: How to only count rows that are current (fulfil a criteria)

    To enter in B13:

    =COUNTIFS(T_Referral[Referral completed],"",T_Referral[Priority],RIGHT([@[Priority Rating]],1))

    This will count how many rows have a blank cell under "Referal complete", and also have the correct priority rating.


    To enter in C3:

    =IF(B3="","",(TODAY()-B3))

    This checks for a blank cell, and if so it returns a blank.

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    7,841

    Re: How to only count rows that are current (fulfil a criteria)

    or:

    =COUNTIFS(T_Referral[Priority],ROW(1:1),T_Referral[Referral completed],"<>Yes")

    Drag down

+ 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. Dynamic Model using if function to fulfil criteria
    By vbarone in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2020, 04:32 PM
  2. to filter rows by current month and 2 Criteria and include hyperlink to url
    By Shamz41 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-17-2019, 02:43 AM
  3. Replies: 4
    Last Post: 11-01-2016, 03:28 PM
  4. Extracting rows that fulfil a criteria
    By adamlamping in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-30-2016, 09:02 AM
  5. [SOLVED] Count of rows in an array that meet criteria in column 2 and different criteria in column3
    By reynoldslarry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 01:51 AM
  6. Replies: 7
    Last Post: 08-06-2013, 11:13 AM
  7. Count the number of rows in active cell's current column using VBA.
    By cool1_boy1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-24-2013, 01:08 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