'Count the number of times a word happens between two dates

What formula can I use to find a specific word between two dates?

I know I can use countifs to find the word for the entire column - but is it possible to do so between two dates?

I've been trying to combine these two formulas to no avail

=countifs(C8:C182,">="&C6,C8:C182,"<="&D6) - this has the dates and can find the amount of times a deal is created.

=countifs(F8:F187,D1) - this can find the amount of times a certain type of deal comes up.

In the image I want to find out what is D and E without having to manually count/ split the data by date aha.

enter image description here

Appreciate the help!

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source