# Subtotals (At least I think that's what I need)

#### O2Girl

##### New Member
I am using Excel 2011 for Mac.

I am creating a workbook with multiple worksheets, one overview sheet and then one sheet for each month of the year.

In the monthly sheets I have a Category column for which I have created a drop-down menu of expense categories. Then I have an Expense Amount column where I enter the amount spent.

The Category column will not necessarily remain sorted by category because I will be entering the expenses as they come up throughout the month so the categories will be all mixed up, unless I manually sort them.

What I want to do is somehow automatically calculate a running subtotal by Category (that will update with each new entry) and simultaneously automatically transfer the running subtotal for each Category to a specific cell on the overview sheet.

I need help figuring this out, please.

### Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

#### Snakehips

##### Well-known Member
02Girl,

Welcome to MrExcel.

Perhaps something like this to create your category sub totals.....

Excel 2007
ABCDE
1Category£CategorySub Total
2Food1Food5
3Sundries2Drink7
4Food2Sundries4
5Drink3
6Drink1
7Food2
8Drink3
9Sundries2
Sheet3
Cell Formulas
RangeFormula
E2=SUMIF(\$A\$2:\$A\$20,D2,\$B\$2:\$B\$20)
E3=SUMIF(\$A\$2:\$A\$20,D3,\$B\$2:\$B\$20)
E4=SUMIF(\$A\$2:\$A\$20,D4,\$B\$2:\$B\$20)

You can put the formulas wherever suits and then pick up those cells to gather overall totals.
Edit the formula to suit your data range.

Hope that helps.

#### O2Girl

##### New Member
Thank you, thank you, thank you!!! That works exactly how I wanted it to!

Replies
2
Views
183
Replies
1
Views
366
Replies
1
Views
464
Replies
0
Views
221
Replies
0
Views
593

1,195,595
Messages
6,010,632
Members
441,558
Latest member
lambierules

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