+ Reply to Thread
Results 1 to 2 of 2

COUNTIFS within a date range but only if a second column meets a specified criteria

  1. #1
    Registered User
    Join Date
    08-28-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    6

    COUNTIFS within a date range but only if a second column meets a specified criteria

    Hi am trying to add a qualifier to return only the number of results that are within the J column containing CRTD and within the date range??

    I think this is close but I am not getting the result I need.

    =COUNTIFS('IW38'!U1:U999,">="&TODAY()-30,'IW38'!U1:U999,"<="&TODAY()-14,'IW38'!J1:J9999,"CRTD*")
    This gets me a #VALUE! error.
    On it's own the date range part works, and the CRTD* works, just getting them to work together is catching me??

    Cheers

    Heath

    ---------- Post added at 03:06 PM ---------- Previous post was at 02:56 PM ----------

    Sorry for the double but I just figured it out, =
    =COUNTIFS('IW38'!U1:U999,">="&TODAY()-30,'IW38'!U1:U999,"<="&TODAY()-14,'IW38'!J1:J999,"CRTD*") Works and
    =COUNTIFS('IW38'!U1:U999,">="&TODAY()-30,'IW38'!U1:U999,"<="&TODAY()-14,'IW38'!J1:J9999,"CRTD*") does not so for some reason the J1:J9999 range was too high??
    Last edited by HeathWilD; 08-29-2012 at 01:20 AM.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: COUNTIFS within a date range but only if a second column meets a specified criteria

    ,'iw38'!j1:j9999,"crtd*") --->>> j999
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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