Forum Discussion
Countifs Using Date Ranges and Additional Criteria
Hiya, I've been looking everywhere for a solution to this but I can't find anything!
Here is a screenshot of part of my data:
What I want to do, in a separate sheet, is have a countif formula that counts the number of rows of data where vacancy status (column G) = Vacancy Approved - Recruit, AND where the date the vacancy was authorised is 90 or fewer days ago. I will then need two more formulas for vacancies authorised between 91 and 180 days ago, and over 180 days ago.
Is this possible?
1 Reply
A possible solution with COUNTIFS or SUMPRODUCT is shown in the attached file.
