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!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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))
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0
I have posted the solution in the other please check and let me know if that works
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top