Formula for how much we spent on a category in specific time period

Google Sheets
,
1

In the transactions sheet column C " category", column D “amount” and column E “address”, we want to be able to see how much amount under the category for each address and select by date.

For example, we want to be able to see how much " Coca Cola(Column E )’" company “Office Expences (Column C)” “Total amount (Column D)” on “Jan 2021 (Column I)”.

Is there a good formula to help us with this question?
Thanks a lot!

2

If I’m understanding what you want to do correctly, this article should help: Visualize Your Spending With a Monthly Pivot Table | Tiller Help Center

3

Thank you so much! It worked!