I'm trying to build out a budget monitoring spreadsheet. I want to pull sum of entries by category and based on the month. The data is in rows as follows and will grow each month as I download our spend. Here is the sample data:
Date Category Amount
03-15-21 Auto 500.00
02-12-21 House 375.00
Ultimately I'll have it displayed with months across columns and categories in rows so we can monitor our budget.
How can I pull out the data by category and month?
I've looked at sumifs, sumproduct, index match, haven't found a solution. I appreciate any guidance.