Adding date range criteria

[amendoza19]

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!

 

[Aryatect]

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))

 

[amendoza19]

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

 

[Aryatect]

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.

 

[amendoza19]

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

 

[Aryatect]

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

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1103841-array-formula-unique-dates-specific-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).