+ Reply to Thread
Results 1 to 3 of 3

Count Based on Date Range

  1. #1
    Forum Contributor
    Join Date
    08-19-2006
    MS-Off Ver
    Excel 365
    Posts
    229

    Count Based on Date Range

    Hi,

    I have a data input as per the attached. I need a formula to count if the dates in column C are within the first week of Jan, then check column D if there is a loan keyed in, then check if the days in column E has exceeded 11 days. The result in the example if one because there 1 that matches all 3 criteria. Please assist. Thank you. I tried using the following formula but it did not work:

    =COUNTIFS(C3:C8,">="&G3,C3:C8,"<="&G8,D3:D8,"<>"&"")+COUNTIFS(E3:E8,">=11")


    I have a cross post here:

    https://www.mrexcel.com/forum/excel-...ate-range.html
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Count Based on Date Range

    Please try
    =COUNTIFS(C3:C8,">="&G3,C3:C8,"<="&G8,D3:D8,"<>",E3:E8,">11")

  3. #3
    Forum Contributor
    Join Date
    08-19-2006
    MS-Off Ver
    Excel 365
    Posts
    229

    Re: Count Based on Date Range

    Hi Bo,
    Thank you and that worked. Appreciate your valuable time and patience.

+ 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] Count unique values based on value with date range
    By papasmurfuo9 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-24-2018, 07:24 AM
  2. [SOLVED] Count based on 3 criteria including date range
    By timarcarze in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 06-13-2013, 01:43 AM
  3. Date Range Count based on multiple conditions
    By Baka Jaimito in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-27-2011, 11:43 AM
  4. Count cells based on date range
    By The_Oakster in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2009, 06:24 PM
  5. Count Cells in a Row based on color and date range
    By indnracn2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-14-2009, 11:12 PM
  6. count unique cells in range based on date
    By leedsd75 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-09-2007, 02:04 PM
  7. Replies: 1
    Last Post: 05-05-2005, 04:06 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