+ Reply to Thread
Results 1 to 2 of 2

Countif Function between dates

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Waukesha, Wisconsin
    MS-Off Ver
    Excel 2003
    Posts
    1

    Red face Countif Function between dates

    Good morning
    I have this formula that I want to count non duplicated items between dates. I am not sure what I am missing.
    =SUM(1/COUNTIFS('Sheet2 (2)'!$H$2:$H$7,'Sheet2 (2)'!$H$2:$H$7,'Sheet2 (2)'!$N:$N,">="&A2,'Sheet2 (2)'!$N:$N,"<="&B2))

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Countif Function between dates

    I am not sure what I am missing.
    You messed
    MS-Off Ver:Excel 2003
    and small example

+ 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. Countif function for dates
    By nitin.asalkar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-23-2012, 09:13 PM
  2. [SOLVED] COUNTIF function not counting dates on 31st
    By mattmorris in forum Excel General
    Replies: 2
    Last Post: 07-03-2012, 10:37 AM
  3. COUNTIF function with Dates & due dates.
    By kcowper in forum Excel General
    Replies: 3
    Last Post: 03-10-2011, 12:51 AM
  4. COUNTIF function Using Dates
    By wbmcwhorter in forum Excel - New Users/Basics
    Replies: 15
    Last Post: 12-01-2009, 01:23 PM
  5. Using Countif function with dates
    By jodapo in forum Excel General
    Replies: 2
    Last Post: 07-27-2009, 11:39 PM
  6. Countif function between two dates
    By caryno in forum Excel General
    Replies: 4
    Last Post: 05-19-2008, 12:25 PM
  7. CountIF Function for dates
    By cakonopka in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2007, 08:26 AM
  8. Replies: 5
    Last Post: 07-19-2006, 12:22 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