SUMIF with date range and dropdown list categories
So I have columns Type (dropdown list, 3 values, Tools, Chemicals, Clothing), Date and Amount ($).
I am trying to come up with a formula to sum amount of $ spent in a certain month in each Type of expense. So, for example, for much was spent in type Clothing between 06/01/18 and 06/30/18.
Is there a way to do it? We have other sheets regarding our budget where there are as many as 4-6 values for dropdown Type column.