OK, so for years now I've had a pretty good budget spreadsheet in Excel. I set it a sheet for each month using the following columns: Date, Description, Credit Card Transaction, Bank Transaction, Balance (which is calculated for each vertically subsequent cell using the bank transaction value), Expense/Income category (which uses a Data Validation drop-down from a separate, hidden sheet), and Category Total. It looks like this:

Columns.png

Now, what I always wanted to do (and have no idea how to go about doing it) is to aggregate all these values for an entire sheet, so, for example, I'd be able to see how much I'd spent in the Computer category for the month of May. Ideally, I'd have this report on a separate sheet.

Does this make sense? Is there any way to do this?