Results 1 to 4 of 4

COUNTIFS Issue w/multiple date conditions

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2016
    Location
    Yakima
    MS-Off Ver
    365
    Posts
    5

    Question COUNTIFS Issue w/multiple date conditions

    I am attempting to: Count all unique text values in the range: B2:B21 that fall between 2 dates specified in the range A2:A21. Using the following:

    =COUNTIFS(DATA!B2:B21,"<>"&" ",DATA!A2:A21,">=1/1/2016", DATA!A2:A21,"<=12/31/2016")

    I'm able to get the total count, but haven't sucessfully been able to get a unique count to function.

    This has got me hung up slightly.

    Any help would be largely appreciated.

    Thanks in Advance.

    J
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. CountIfs With Multiple Conditions
    By 5150 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-13-2015, 11:16 AM
  2. COUNTIFS multiple conditions
    By akkerstad in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-04-2014, 03:38 PM
  3. Countifs over multiple worksheets issue
    By luciedefreitas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-28-2014, 09:10 AM
  4. Adding multiple COUNTIFS issue
    By purdue7997 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-17-2013, 06:40 AM
  5. CountIfs By Month - Multiple Date and Text Conditions
    By MAC0605 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-08-2013, 06:22 PM
  6. [SOLVED] CountIfs With Multiple Conditions
    By NotQuiteThere in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-18-2012, 09:35 PM
  7. Countifs for multiple conditions
    By batjl9 in forum Excel General
    Replies: 4
    Last Post: 03-25-2011, 09:07 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