Status
Not open for further replies.

#### amendoza19

##### New Member
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!

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

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

#### Aryatect

##### Active Member
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
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
I have posted the solution in the other please check and let me know if that works

#### Fluff

##### MrExcel MVP, Moderator
Status
Not open for further replies.