Sum a list of entries while grouping them by month and category

[Facens]

Hi,
I have two sheets. I want to sum a list of entries that I have on one sheet while grouping it by month and category on another sheet. I'll explain better.

On the first sheet
Here I have something like this

As you can see, a list of months horizontally and a list of cost categories vertically.

On the second sheet

Here as you can see I have a list of costs that I categorize using the same categories from the first sheet, each one with a Date.

How can I fill the first sheet with the data from the second, so that they are summed in the right month and category?

-

This is my first post, so I thank you in advance and let me know if there is something I can do to explain better, as well as something I've done wrong

 

[Facens]

Also: I use Excel 2011 for Mac

 

[Facens]

Hi guys, any suggestions?

Thanks again

 

[Jim Gordon]

Do you want the information in Sheet 2 to appear as drop downs from which to choose in the grid on sheet 1?

 

[Facens]

@Jim, thanks a lot for offering your help. I sorted it out and this is the solution:

The following formula

=SUMIFS(‘Cost entries'!$C$2:$C$9999;'Cost entries'!$B$2:$B$9999;$A7;'Cost entries'!$A$2:$A$9999;">="&B$2;'Cost entries'!$A$2:$A$9999;"<"&C$2)

goes into the highlighted cell here:

Where the Cost Entries sheet is the following:

Hope this helps any future surfers