+ Reply to Thread
Results 1 to 3 of 3

running Countif between two dates and other criteria

  1. #1
    Registered User
    Join Date
    04-28-2022
    Location
    Canton, Michigan US
    MS-Off Ver
    365
    Posts
    32

    running Countif between two dates and other criteria

    Getting stuck with the between two dates, just returning 0 as value. I need a formula for the highlighted column in the attached.

    The count needs to reset at each calendar year.
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: running Countif between two dates and other criteria

    Try this:

    =COUNTIFS(C$2:C2,C2,A$2:A2,">="&DATE(YEAR(A2),1,1),B$2:B2,"<="&DATE(YEAR(A2),12,31))

  3. #3
    Registered User
    Join Date
    04-28-2022
    Location
    Canton, Michigan US
    MS-Off Ver
    365
    Posts
    32

    Re: running Countif between two dates and other criteria

    Thank you. It works beautifully.

+ 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 with multiple criteria and due dates
    By gregorkroselj in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-09-2021, 06:16 PM
  2. [SOLVED] COUNTIF between 2 dates and also contains a text criteria
    By Kellykix in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2021, 01:35 AM
  3. [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
  4. [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
  5. [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
  6. 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
  7. Use multiple criteria with COUNTIF: between dates and not blank
    By l.shields in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2006, 02:25 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