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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

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,641
Messages
5,488,049
Members
407,619
Latest member
obriende

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top