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

#### Facens

##### New Member
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

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Also: I use Excel 2011 for Mac

Hi guys, any suggestions?

Thanks again

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

@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

Replies
1
Views
382
Replies
1
Views
84
Replies
6
Views
129
Replies
6
Views
179
Replies
5
Views
228

### Forum statistics

1,196,448
Messages
6,015,324
Members
441,889
Latest member
balolaptopgiaolong

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back