Countifs Using Date Ranges and Additional Criteria

New Contributor

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.