# Need help with summarizing from a table - dsum?

#### Jewelzrk

##### New Member
For example, my worksheet is setup like this:

New York California California New York
Company1 Company2 Company3 Company4
Sales 1000000 2000000 Income
Expenses 4444 44444 Income
Cash 1000 500 Balance Sheet
Receivables 5 100 Balance Sheet

I want to create a formula that pulls the subtotal of all balance sheet item amounts for a particular state... so as in this example the total for california would be \$11,505

I have a dsum formula for the income vs balance sheet #, but how would I go about breaking it down further by state?

edit: i guess it doesn't show up correctly on the post, but you should be able to see it if you click quote

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### DonkeyOte

##### MrExcel MVP
have you thought about using a Pivot Table based off your data table ?

#### Jewelzrk

##### New Member
hmm... I have some experience with pivot tables but I'm looking for something thats easily updated as changes are made and can be linked to

##### MrExcel MVP
That's still a pivot table...

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,682
Messages
5,838,784
Members
430,568
Latest member
bortey

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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