+ Reply to Thread
Results 1 to 4 of 4

Countifs crtierias with dates

  1. #1
    Registered User
    Join Date
    03-18-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Countifs crtierias with dates

    hi

    so im looking to could the number of say "D" for deaths given the dates is less than a certain date e.g.

    A B

    1 1/03/2007 D
    2 3/04/2007 L
    3 2/06/2008 D
    4 3/09/2007 D
    5 5/10/2007 n/a


    say if i want the date to be less than 31/12/2007 and D

    i would use -
    =COUNTIFS(B1:B5,"D",A1:A5,A1:A5<C1)

    where C1 is 31/12/2007

    i should get 2 for the result however the formula gives me a 0..

    is it something to do with the formating of the date or is the countif formula i used wrong?

    thanks
    Last edited by lucky3; 03-19-2012 at 08:04 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Countifs crtierias with dates

    Try:

    =COUNTIFS(B1:B5,"D",A1:A5,"<"&C1)


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-18-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Countifs crtierias with dates

    wow that works

    thankyou very much

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,086

    Re: Countifs crtierias with dates

    You're welcome ... you sound surprised.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ 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