+ Reply to Thread
Results 1 to 5 of 5

CountIfs By Month - Multiple Date and Text Conditions

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    At the Office, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Question CountIfs By Month - Multiple Date and Text Conditions

    This is my second attempt - for some reason my first attempt failed to create a new thread.


    I have a data set (col. A-U) and I am trying to count the number of records that meet the following criteria for each month in 2012. Some records might be included for each month of the year, some may only be included in the totals for Jan-Jun, etc. The criteria for counting a record are as follows:
    col. M = "text"
    col. B (date) </= (i.e. is earlier than) "Jan-2012," "Feb-2012," etc.
    col. C (date) < "Jan-2012," "Feb-2012," etc.
    col D (date/text) < "Jan-2012," "Feb-2012," etc. OR Is Blank

    The output would (ideally) look something like this:

    Jan-2012 Feb-2012 Mar-2012 Apr-2012 May-2012...
    49 49 51 53 48

    I hope my question makes sense. Thanks in advance for any assistance!

  2. #2
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: CountIfs By Month - Multiple Date and Text Conditions

    MAC,

    Make sure the dates are actual dates and not text...

  3. #3
    Registered User
    Join Date
    01-08-2013
    Location
    At the Office, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: CountIfs By Month - Multiple Date and Text Conditions

    Thanks! I changed the Cell Format for the columns and headings noted above to "Short Date;" however, col. C does contain some values that are actually text versus mm/dd/ccyy. Not sure if that is all it takes to ensure the formula will work correctly or not...

  4. #4
    Valued Forum Contributor
    Join Date
    09-10-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    929

    Re: CountIfs By Month - Multiple Date and Text Conditions

    Hi MAC,

    Is it possible if you attach a sample spreadsheet? Please include a sample and what results that you want to show.
    Click on Go Advance and look for a paperclip...

    In your example above, shouldn't the numbers be accumulating? Why does it dip in May? Are there negative numbers too?

    Thanks,
    Dennis

  5. #5
    Registered User
    Join Date
    01-08-2013
    Location
    At the Office, USA
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: CountIfs By Month - Multiple Date and Text Conditions

    Sorry for the confusion. To clarify, I am trying to find out how many employees were on the roster for each month in 2012 with a particular qualification. Col. B represents the Hire Date, Col. C represents the Date of Qualification and Col. D represents the Last Date of Employment. So depending on the inflow/outflow of employees each month the totals for the months might fluctuate in either direction. I hope that makes sense but I'll dummy up a sample tomorrow and post it to help clarify further.

    Thanks!

+ 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