+ Reply to Thread
Results 1 to 2 of 2

Count Unique ID's across multiple sheets with multiple criteria

  1. #1
    Registered User
    Join Date
    09-04-2019
    Location
    Kansas City, KS
    MS-Off Ver
    Excel 2016
    Posts
    1

    Count Unique ID's across multiple sheets with multiple criteria

    Image.png

    I have apps A, B, C, D with different issue ID's, open dates, status, and closed dates (if closed).
    A closed issue might show up on the ALL tab and closed tab, until the ALL tab has been updated.
    I'm trying to make a dashboard and want a count of the issues that have had an open status this tracked year (10/1/18-9/30/19). So either open now (blank closed date) or closed after 9/30/18.
    I do not want to include Issues with IDs that have Iss or Wro in the name.
    Is there a formula that can count unique issue ids for app *, excluding iss and wro issues, that have had an opened status within the tracked year (10/1/18-9/30/19).

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,896

    Re: Count Unique ID's across multiple sheets with multiple criteria

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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] Formula to count matches between multiple columns on different sheets w/ multiple criteria
    By RICK JAMES in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-05-2019, 03:28 PM
  2. Count unique over multiple sheets.
    By gunnell in forum Excel General
    Replies: 4
    Last Post: 08-06-2018, 03:32 PM
  3. Replies: 0
    Last Post: 01-11-2013, 02:39 AM
  4. count unique values in multiple worksheets with multiple criteria
    By craig04 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2012, 03:26 PM
  5. Replies: 8
    Last Post: 07-13-2012, 06:00 AM
  6. Count - multiple criteria, multiple sheets, and date range.
    By threecliffs in forum Excel General
    Replies: 6
    Last Post: 06-14-2011, 01:36 PM
  7. Count unique logs with multiple conditions of multiple sheets
    By Robert Bob in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-12-2007, 12:49 AM

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