Adding date range criteria

Status
Not open for further replies.

amendoza19

New Member
Joined
Jul 12, 2019
Messages
14
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!
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Aryatect

Active Member
Joined
Jun 17, 2019
Messages
308
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))
 

Aryatect

Active Member
Joined
Jun 17, 2019
Messages
308
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

New Member
Joined
Jul 12, 2019
Messages
14
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

Active Member
Joined
Jun 17, 2019
Messages
308
I have posted the solution in the other please check and let me know if that works
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,102,474
Messages
5,487,096
Members
407,577
Latest member
afonsomira

This Week's Hot Topics

Top