COUNTIFS date from Column A > date in Column B

Hi everyone,
backround:
Here's the problem. We need to meet users before they leave from the company. the only problem is sometimes we get the departure emails after they leave. I need a monthly summary of the people we dont meet, that we recieved the email before they leave.
or i cant figure the red part out, I need a count of: departure date(columnA) between x and y AND met user(column C) = no AND departure date(column A) > email reception date(column B)

Im already using a countifs formula to determine if we met users leaving and right now I have a hidden field with a simple > formula but I would really like to eliminate it. I had also tried the sumproduct with -- that i could just subtract from the countifs but I could not find a way to limit it to a date range.

thanks

You can't do that with COUNTIFS, try SUMPRODUCT, something like this

=SUMPRODUCT((A$2:A$100>D1)*(A$2:A$100<D2)*(C$2:C$100="No")*(A$2:A$100>B$2:B$100))

where D1 and D2 define the date range