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.