+ Reply to Thread
Results 1 to 4 of 4

countif based on a date range

  1. #1
    Registered User
    Join Date
    10-10-2006
    Posts
    24

    countif based on a date range

    I have 2 columns, one containing a piece of data and one containing dates. I want to count how many times the data is in the first column, based on a specific date range in the 2nd column. I have attached a sample SSF with a better explanation inside it.
    Attached Files Attached Files
    Last edited by mamig; 01-13-2010 at 12:36 PM. Reason: solved

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: countif based on a date range

    Given your Quarters are Calendar based you could just use a Pivot Table.

    Set Region as Row Field
    Set DOI as Column Field -> Right Click on this Field -> Group -> Quarters & Year
    Set Region as Data Field -> set to COUNT

    This will generate your matrix for you efficiently.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: countif based on a date range

    If you still wanted a formula (I'd use a PT myself) - assuming data is all one year:

    Please Login or Register  to view this content.
    If not one year - add a YEAR test.

  4. #4
    Registered User
    Join Date
    10-10-2006
    Posts
    24

    Re: countif based on a date range

    Thank you. The formula is exactly what I needed. Works great

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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