+ Reply to Thread
Results 1 to 3 of 3

COUNTIF between 2 dates and also contains a text criteria

  1. #1
    Registered User
    Join Date
    01-07-2021
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    11

    COUNTIF between 2 dates and also contains a text criteria

    Hi all,

    I'm looking for a countif formulae that will that will look only within a certain range of dates, for cells that contain a certain text.

    I have a massive spreadsheet tracking data from the past 4 years and into the future.

    I have one column (Column M) of dates, I want to only look at data between 1 Oct 2020 - 31 Dec 2020.

    I have a different column (Column O) that contains text "On Time", "Late".

    So, I want to count the number of "On Time" between 1 Oct 2020 and 31 Dec 2020.

    Any help is appreciated.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: COUNTIF between 2 dates and also contains a text criteria

    Try:

    =COUNTIFS(M:M,">="&DATE(2020,10,1),M:M,"<="&DATE(2020,12,31),O:O,"On Time")
    Quang PT

  3. #3
    Registered User
    Join Date
    01-07-2021
    Location
    Perth, Australia
    MS-Off Ver
    2016
    Posts
    11

    Re: COUNTIF between 2 dates and also contains a text criteria

    that worked perfectly! Thanks so much

+ 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] How to use COUNTIFS and COUNTIF with multiple criteria using dates
    By rowena229 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2020, 02:10 PM
  2. [SOLVED] Countif between 2 dates with multiple criteria
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-15-2015, 09:22 AM
  3. [SOLVED] Countif between 2 dates and multiple criteria
    By Sasquatch2014 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2015, 10:55 AM
  4. [SOLVED] Countif (or maybe it's Sumproduct?) meets two criteria and between two dates
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2014, 12:50 PM
  5. Return dates that match a single criteria (a countif criteria)
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-07-2014, 12:43 PM
  6. Multi-criteria countif functions for dates...possible?
    By Rekli in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-11-2006, 05:51 PM
  7. [SOLVED] COUNTIF, dates and blank cell criteria
    By luvthavodka in forum Excel General
    Replies: 6
    Last Post: 06-01-2006, 04:55 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