|
|
|
|
#2
10-01-2014, 08:19 AM
|
|||
|
|||
Thank you. I understand. What I don't understand is how to put it in the statement in order to return the results I need. What I have right now is:
Range("AI7").Select ActiveCell.FormulaR1C1 = _ "=COUNTIFS([DPA_ScheduledReport.csv]DPA_ScheduledReport!R[-4]C7:R[9994]C7,""success"",[DPA_ScheduledReport.csv]DPA_ScheduledReport!R[-4]C15:R[9994]C15," > " & today()+7/24"")" Obviously it needs to go someplace else since I am only getting a TRUE instead of a number. I just don't know where. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can you review status in Project from a previous time prior to "Today" | StevieMar | Project | 3 | 04-30-2014 09:42 AM |
| Auto Forward Emails - Specific Time Periods Only | Dav | Outlook | 0 | 06-22-2011 12:03 PM |
| how to make the task starts next day if no time enough today(task can not be split) | duraid | Project | 1 | 10-25-2010 08:31 AM |
| outlook 2000 pst greater than 2gb | bbxrider | Outlook | 0 | 09-25-2010 02:37 PM |
 If A1 greater than or equal to 1 Then A3 = A2*A1
|
brians | Excel | 5 | 03-09-2010 12:04 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode