Adding date range criteria
Results 1 to 7 of 7

Thread: Adding date range criteria
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Adding date range criteria

    Hello everyone,

    I have a quick question, how can I add a date range to the fllowing formula?
    =SUM(IF(FREQUENCY(IF('Master expense sheet '!C:C=Summary!D2,'Master expense sheet '!J:J),'Master expense sheet '!J:J)>0,1))
    basically i just want it to do the same thing but just for anything less than 1/1/2019

    Thank You!
    0 0
     

  2. #2
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    301
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding date range criteria

    Hi, Check if this works:

    =SUM(IF(FREQUENCY(IF(('Master expense sheet '!C:C=Summary!D2)*([Date Range]<"1/1/2019"),'Master expense sheet '!J:J),'Master expense sheet '!J:J)>0,1))
    Thanks!

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    0 0
     

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding date range criteria

    it gives me an error saying the name i entered is incorrect
    0 0
     

  4. #4
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    301
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding date range criteria

    Sorry I forgot to mention, in place of [Date Range] you will have refer to the column where you are looking for dates and have to use Ctrl+Shift+Enter to enter the formula.
    Thanks!

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    0 0
     

  5. #5
    New Member
    Join Date
    Jul 2019
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding date range criteria

    Ok I did that and it fixed that but now its giving me the same values from the very first formula without the date range
    =SUM(IF(FREQUENCY(IF(('Master expense sheet '!C:C=Summary!D2)*('Master expense sheet '!J:J<"1/1/2019"),'Master expense sheet '!J:J),'Master expense sheet '!J:J),1))
    I even tried it with the >0,1 but that didn't change anything either
    0 0
     

  6. #6
    Board Regular Aryatect's Avatar
    Join Date
    Jun 2019
    Location
    Chicago, USA
    Posts
    301
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding date range criteria

    I have posted the solution in the other please check and let me know if that works
    Thanks!

    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes
    0 0
     

  7. #7
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    25,519
    Post Thanks / Like
    Mentioned
    444 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Adding date range criteria

    Duplicate https://www.mrexcel.com/forum/excel-...fic-names.html

    Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
    Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10
    0 0
     

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •