Choose a date range and a criteria to return a sum of values

Hello,

I am looking into making a personal file but find myself in a bit of trouble with Numbers functions.

I have a table that would look like that:

And I would like to be able to choose a date range (either two specific dates, or a specific month, or year), as well as one or multiple “Expense” criteria from the pop-up menu so that it adds together their price paid for that period of time.

I think it could look like that:

The more I think about it, the more I think it could be easier for me to have as many separated result tables as there are criteria so I can mix and match without bothering too much with heavy formulas, so that’s an option for sure.

Now I just don’t know how to refer to specific dates in formulas, and I would also like to be able to select a month or a year without having to type in “01/07/2021 - 31/07/2021” or “01/01/2021 - 31/12/2021” but “July” or “2021” instead (is that even possible?)

I can work on it either on Numbers for iPad or mac.

Thank you for your time if you read this!