Google-sheets – Sum by month and then by month and category formula

formulasgoogle sheets

Cross-post

I've been trying to figure this out for weeks. It's a spreadsheet to help people understand their spending habits.

They enter their monthly expenses on one sheet, and the other calculates what they spent in a month total, and what they spent by each category each month.

Best Answer

this is how you SUM by month: https://docs.google.com/spreadsheets/d/

for the 2nd part, you first need to build some matrix where a category will be assigned to individual expenses because, at the current state, spreadsheet cant tell that TELUS CABLE is considered to be in Cable category. and only then, just after the categorization of expenses, you will be able to call for the right data to be broken down as you desire it.