+ Reply to Thread
Results 1 to 4 of 4

COUNTIFS matching a range

  1. #1
    Registered User
    Join Date
    04-16-2019
    Location
    Phoenix, AZ
    MS-Off Ver
    O365
    Posts
    6

    COUNTIFS matching a range

    I have seen the COUNTIFS(Table1[Service Status],{"Complete","In Work"}) type of formulas, but i am wanting the portion between the curly braces to be dynamic pulled from another table.
    Similar to the IN function within SQL.

    I have tried multiple things and searched for a while now, so any assistance is greatly appreciated. :P
    Last edited by bahalzamon; 10-19-2023 at 01:50 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: COUNTIFS matching a range

    Pretty sure that only works with constant values, not cells or ranges. There's probably a way though.

    I don't have the Table but it would look something like this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I'm sure there are better ways.



    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: COUNTIFS matching a range

    The criteria-parameter of the function COUNTIFS can be a dynamic table.

    For example:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-16-2019
    Location
    Phoenix, AZ
    MS-Off Ver
    O365
    Posts
    6

    Re: COUNTIFS matching a range

    thank you, ill give this a shot.
    i was on a bit of a deadline so i just made a simple helper column in the data source with a vlookup and iferror.
    i have never used the let command before.

+ 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. COUNTIFS with two criteria and matching names
    By 06cards in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-15-2022, 02:43 PM
  2. [SOLVED] Countifs - Matching a Date Range
    By JasonMcQueen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2021, 04:57 AM
  3. Replies: 3
    Last Post: 08-02-2018, 02:59 PM
  4. [SOLVED] Countifs matching rows and column values
    By Excelmagster in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-05-2017, 10:51 AM
  5. [SOLVED] Countifs matching
    By RachelMads02 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2017, 12:03 PM
  6. [SOLVED] Alter Matching Sub From matching two Ranges to matching one range and list
    By capson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-14-2015, 10:48 PM
  7. Indexing and matching data from date range and matching
    By Rickomicko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2013, 11:46 AM

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