Hi!
There are many complex ways to do this and often times you may just think to use a formula to solve the problem. But, that is making this issue way too complex. There is actually a pretty simple way to do this using a PivotTable.
So, here are the steps to follow to get this information in the PivotTable:
- Enter a column next to the Date column and Call it "Month"
- In that column, enter this function in the first cell and copy it down =MONTH(B3) - make sure the cell is formatted as "General" and you will get a numerical representation of the month (1-12)
- Select all of the data from the Bank header down and go to the Insert tab, click PivotTable, and hit OK to input it onto a new worksheet.
- Go to the new tab and put a check mark next to Month, Category, and Debit.
- At the bottom of the pane on the right side, put Month into the Row Labels box; put Category into the Column Labels box; and, put Debit into the Values box.
This should give you the information that you were looking for in an easily manipulative format. PivotTables cab be confusing at first, but once you play around with them a bit, you will see how much easier they can make your life in Excel.
Hope this helps