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:

 

LL19911695_0-1648797845691.png

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

@LL19911695 

A possible solution with COUNTIFS or SUMPRODUCT is shown in the attached file.