Expense category totals per month from list

[Yosepht]

Hi,

I need to create a formula that will determine the month an expense occurred and its type and add its cost (left table) to the respective expense category and month on the totals table (right table).

I've attached the layout I intend to use for the system. if anyone could put this together it would help me tremendously!

Thank you!

 

[arthurbr]

Looks perfect for a Pivot Table

 

[Yosepht]

The pivot table doesn't seem to update as I enter new expenses. Is this supposed to happen?

 

[arthurbr]

You will have to organize your data as an Excel Table and refresh it with one of these techniques