Countifs formula for multiple factors

[Jeffmonster]

Hi Guys and Gals,
I have a question for you all:

I have a spread sheet I'd like to track and categorize based on multiple criteria (columns) based on a date range.

For example: 5/27/2018 - 6/2/2018
Based on that date range I'd like to have the sheet auto calculate based on the Market, Type and Date set into the following categories:
Austin Buyer Appts Set = (Market: Austin, Type: Buyer, Date set = 5/27-6/2)
Austin Seller Appts Set
San Antonio Buyer Appts Set
San Antonio Seller Appts Set

I've attached a screenshot for reference.

[/IMG]

 

[oldbrewer]

market

type

date set

date met

san

sell

25/05/2018

austin

sell

25/05/2018

san

buy

26/05/2018

let date range be

austin

sell

26/05/2018

san

sell

27/05/2018

from

27/05/2018

austin

buy

28/05/2018

to

08/06/2018

san

sell

28/05/2018

austin

sell

29/05/2018

let type =

san

buy

29/05/2018

austin

sell

30/05/2018

type

buy

san

sell

31/05/2018

austin

buy

31/05/2018

san

sell

01/06/2018

let market =

austin

sell

01/06/2018

san

buy

02/06/2018

market

austin

austin

sell

03/06/2018

san

sell

03/06/2018

austin

buy

04/06/2018

4

san

sell

04/06/2018

austin

sell

05/06/2018

formula

san

buy

06/06/2018

austin

sell

06/06/2018

=SUMPRODUCT(($A$2:$A$31=$K$16)*($B$2:$B$31=$K$11)*($C$2:$C$31>=$K$6)*($C$2:$C$31<=$K$7))

san

sell

07/06/2018

austin

buy

07/06/2018

san

sell

08/06/2018

austin

sell

09/06/2018

27/05/2018

to

08/06/2018

san

buy

09/06/2018

austin

sell

10/06/2018

buy

sell

san

sell

10/06/2018

san

3

7

austin

buy

11/06/2018

austin

4

6

formula for san buy =3

=SUMPRODUCT(($A$2:$A$31=$H30)*($B$2:$B$31=I$29)*($C$2:$C$31>=$I$27)*($C$2:$C$31<=$K$27))

<colgroup><col span="2"><col><col span="5"><col><col><col><col span="6"></colgroup><tbody>
</tbody>